Post reply

Setting Collation during the SQL Server Setuo

  • June 23, 2006 at 6:07 am

    #61277

    How to choose the below collation for SQL Server 2000 during installation?

    "Latin1-General,

    case-insensitive,

    accent-sensitive,

    kanatype-insensitive,

    width-insensitive for Unicode Data,

    SQL Server Sort Order 42 on Code Page 850 for non-Unicode Data"

    It's equivalent collation is "SQL_Latin1_General_CP850_CI_AS"

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

  • June 23, 2006 at 6:21 am

    #645503

    Oops! Find that.

    By selecting SQL Server collation sort order as "

    42 Dictionary order, case-insensitive, for use with the 850 (Multilingual) character set."

    got that "SQL_Latin1_General_CP850_CI_AS"

    Sivaprasad S - [ SIVA ][/url]http://sivasql.blogspot.com/[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply