|
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.
(comments are locked)
|
|
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 thanks, I should have been more specific. I am looking for a way to install it with this collation from the start.
Jun 22 '10 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 '10 at 11:18 AM
Kev Riley ♦♦
I should have said, do the install without changing the default collation settings
Jun 22 '10 at 11:23 AM
Kev Riley ♦♦
(comments are locked)
|
