Collation definition

• warren2600

  SSC-Addicted

  Points: 499

  More actions

  June 1, 2006 at 7:35 am

  #113209

  quick question:

  what does CP1 mean in the default collation SQL_Latin1_General_CP1_CI_AI?

  i have a customer who's collation is missing the CP1 in their set.

  Thanks,

  warren

• Pam Brisjar

  SSChampion

  Points: 12094

  More actions

  June 1, 2006 at 7:58 am

  #641179

  http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_5ell.asp

   

  CP1 specifies code page 1252, for all other code pages the complete code page number is specified.