Post reply

Configuring case sensitive and UTF-16

  • November 13, 2009 at 2:27 pm

    #212289

    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

    #1079369

    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

    #1080238

    Hello,

    Thanks so much for your help.

    my database lenguage is english

    regards.

  • November 17, 2009 at 9:00 am

    #1080323

    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