Post reply

Finding Collation

  • September 9, 2009 at 11:57 am

    #214221

    Hi All,

    Can anyone tell me which collation option needs to be selected while deploying sql server 2005 to get SQL_Latin1_General_CP1_CI_AS

    server collation

    Regards,

    Naveen

  • September 9, 2009 at 2:56 pm

    #1051451

    I think this is default one.

  • September 9, 2009 at 5:48 pm

    #1051504

    during setup you have to choose SQL_Latin1_General_CP1 + Case Insensitive and Accent Sensitive

    default collation depends on server's regional settings

  • September 10, 2009 at 4:49 am

    #1051650

    Thanks a Lot,

    Its a default setting with definition:- dictionary order, case-insensitive for use with 1252(English) Character Set

    Thanks again

  • September 10, 2009 at 4:50 am

    #1051651

    Also, the regional setting should be English(United States)

Viewing 5 posts - 1 through 4 (of 4 total)

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