x

SQL_Latin1_General_CP1_CI_AS as default collation for SQL Server 2005 64x Standard Edition SP3

Anyone know how to set this up as the default collation? I tried several options, including SQL Collations: Dictionary Order, Case Insensitive, for use with 1252 Character Set, and Collation designator and sort order: Latin1_General, Accent Sensitive. Neither of these gave me SQL_Latin1_General_CP1_CI_AS, they were Latin1 (without the preceding SQL). While they are similar, they are not the same, and we were having conflicts with 3rd-party programs that need this specific collation set. It would be nice if there would be an initial way to install it with this setting, without having to rebuild the master database.

Not sure how much of this is relevant, but the server is running Microsoft Windows Server 2003 R2, 64-bit machine. It originally had SQL Server 2005 Express installed. We uninstalled this, and installed SQL Server 2005 Standard Edition 64x, then upgraded it to SP3.

more ▼

asked Jun 18, 2010 at 10:47 AM in Default

jatkin gravatar image

jatkin
25 2 2 2

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

To change the server collation, which will be the default collation for all databases created on it unless specified otherwise, you will need to rebuild the master database, as you have probably already read


Update: following on from jatkin's comment

BOL states that English (United States) locale corresponds to SQL_Latin1_General_CP1_CI_AS

more ▼

answered Jun 18, 2010 at 11:41 AM

Kev Riley gravatar image

Kev Riley ♦♦
53.9k 47 49 76

thanks, I should have been more specific. I am looking for a way to install it with this collation from the start.
Jun 22, 2010 at 09:13 AM jatkin
jatkin: can you confirm what the language of the server is set to. One option may be to change it to US English, do the SQL install, and then revert back to whatever language you need
Jun 22, 2010 at 11:18 AM Kev Riley ♦♦
I should have said, do the install without changing the default collation settings
Jun 22, 2010 at 11:23 AM Kev Riley ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x1951
x22

asked: Jun 18, 2010 at 10:47 AM

Seen: 4869 times

Last Updated: Jun 18, 2010 at 10:47 AM