November 13, 2009 at 2:27 pm
Hi,
I need to create a case sensitive database and support UTF-16.
Do you have any idea?
Thaks.
November 14, 2009 at 8:14 am
agil (11/13/2009)
Hi,I need to create a case sensitive database and support UTF-16.
Do you have any idea?
Thaks.
SQL Server does not use UTF16 it uses UCS-2 which is close to UTF16 and there are two ways to get case sensitive collation you could use BIN(binary sort) the fastest sort of the collation you need or use plain case sensitive sort of the collation you need. Now if you can tell me your language or languages I can help with the collations you can use.
Kind regards,
Gift Peddie
November 17, 2009 at 7:26 am
Hello,
Thanks so much for your help.
my database lenguage is english
regards.
November 17, 2009 at 9:00 am
agil (11/17/2009)
Hello,Thanks so much for your help.
my database lenguage is english
regards.
Here are the collation definition when Microsoft says Expression it means collation in your queries which is new to SQL Server 2005. The first page give you all the collation you need in Case Insensitive format while the second page covers Case sensitive and other special collations. You still have the other option which is BIN for the collation you choose because BIN is case sensitive by default.
http://msdn.microsoft.com/en-us/library/ms143508.aspx
http://msdn.microsoft.com/en-us/library/ms143515.aspx
Kind regards,
Gift Peddie
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply