SQL Server Collation question

• Jpotucek

  SSCoach

  Points: 18583

  More actions

  November 29, 2010 at 12:03 pm

  #231937

  I am installing a named instance on (SQL Server 2005 (64bit) Standard Edition)

  I need to mimic an existing installation which has the following collation:

  Latin1_General_CP1_CI_AI

  During the install I choose SQL_Latin1_General and the final product is a collation of Latin1_General_CI_AI

  What check marks do I have to use in order to get Latin1_General_CP1_CI_AI???

  Thank you!!!

• Evil Kraig F

  SSC Guru

  Points: 100851

  More actions

  November 29, 2010 at 12:08 pm

  #1256422

  You have to specify the code page, 1252.

  See here:

  http://msdn.microsoft.com/en-us/library/ms180175.aspx

  Future note, easily located via google. Search sql server collation CP1.

  ---

  - Craig Farrell

  Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

  For better assistance in answering your questions[/url] | Forum Netiquette
  For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
  Twitter: @AnyWayDBA

• Jpotucek

  SSCoach

  Points: 18583

  More actions

  November 29, 2010 at 12:21 pm

  #1256428

  Thank you. I missed that in the drop-down.. and your link helped : )