Configuring case sensitive and UTF-16

  • Hi,

    I need to create a case sensitive database and support UTF-16.

    Do you have any idea?

    Thaks.

  • 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

  • Hello,

    Thanks so much for your help.

    my database lenguage is english

    regards.

  • 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