Collation configuration in SQL Server 2005 Express setup

The CI and AI bits mean "Case Insensitive" and "Accent Insenstive" (which are checkboxes in the installation dialog if I remember correctly). The CP1 part is, I think, "Code Page 1" and refers to the US region whereas without CP1, it refers to the UK region (or maybe, more generally, non-US English) - this may also be a separate selection in the installation dialog.

If you don't se these options, it will default to the codepage most suitable for the system default international settings in Windows (note: this may not be the same as your profile's international settings) at the time of installation. You can change these (both yours and the system default) via the control panel.

UPDATE:

I've downloaded and run through the installation for SQL Server Express 2005 (SP3)...

I deselected "Hide advanced configuration options" on the "Registration Information" page (but not sure if this was necessary). On the Collation Settings" page I selected "SQL collations (used for compatibility...)" and then "Dictionary order, case-insensitive, accent-insensitive, for use with 1252 Character Set". Everything else was left on defaults.

The result was a SQL Server Express 2005 installation using the SQL_Latin1_General_CP1_CI_AI collation.

More information on this topic can be found here: http://msdn.microsoft.com/en-us/library/ms180175.aspx

Thank you! Yes, I see those check boxes. I didn't know what AI and CI meant.

Brian Roisentul 2010-05-12 18:56:47

I'm sorry, that didn't solve my problem. What you told me is for Latin1_General_CI_AI, but I need the collation that begins with "SQL": SQL_Latin1_General_CI_AI. I've been told that I have to check something from the Background settings but I don't know what.

Brian Roisentul 2010-05-12 19:02:05

This may be useful: http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=69031. Are yu doing a custom or default installation? If you do a custom installtion yo can choose the collation explicitly (just choose US English if given the option)

Daniel Renshaw 2010-05-13 07:48:46

I've updaed my response with what I hope is a definitive answer.

Daniel Renshaw 2010-05-13 08:14:27

Thanks! Now it is :)

Brian Roisentul 2010-05-13 12:24:09

ansaurus

tags:

views:

answers:

Collation configuration in SQL Server 2005 Express setup

related questions