Finding Collation

  • 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

  • I think this is default one.

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

    default collation depends on server's regional settings

  • Thanks a Lot,

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

    Thanks again

  • 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