Re: theory and practice: ying and yang

On 26 May 2005 05:45:43 -0700, "DM Unseen" <dm_unseen_at_hotmail.com> wrote:

>I do know that for SQL Server 2005 user defined types are actually
>special .NET objects that can live inside a database field (probably a
>BLOB field of some sort) by using .NET object serialization(i.e.
>converting the status info of an object to XML and probably compress
>the XML file and store it in a BLOB field).

No, you can use a binary although rather inefficient format (Microsoft still is Microsoft).

>Knowing this I fear SQL server will use this "totext" property for all
>operations like ordering/equality etc :(

No, this is not correct. You can use the binary representations to perform the comparation operations.

http://msdn.microsoft.com/msdnmag/issues/04/02/UDTsinYukon/

Regards Received on Thu May 26 2005 - 18:13:43 CEST