February 23, 2007 at 5:36 am
Hi,
I have a SQL server standard edition that I just installed. I want the collation after installation to read :
SQL_Latin1_General_CP1_CI_AI , but it shows
SQL_Latin1_General_CI_AI......
My question is how in earth I can set the "CP1" during installation ? Can I change this after installation. NOTE, I want to set this for the complete installation, it will not be enough to change it only on the different database levels
Help extremelly appreciated !!
//Helmut
February 23, 2007 at 9:23 am
you need to do a rebuild master to change server collation, any existing database you detatch first will then need to be recollated.
I don't have a free box to step through an install but it's a choice of the sql collation.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 23, 2007 at 10:23 am
Hi
Thanks for the answer......what I dont understand is how I can get the "CP1" added to the collation..if I go properties for my sql server installation it reads SQL_LAtin1_CI_AI
I have reinstalled sql server and I cant understand what to do during installation to get collation equals : SQL_LAtin1_CP1_CI_AI ...I need the CP1 setting for my installation....I want to handle this at installation time because I dont want to start rebuilding stuff in the master DB after installation...it must be possible to get this CP1 already at installation time but how ??? for the case and accent (CI / AS) there are check boxes during install, but what about the CP1 during installation ??
Someone please ??
Best Regards
Helmut
February 23, 2007 at 3:04 pm
if no-one posts then I'll run an install on sunday on a test server - think you need code page 850 , sorry not really sure I usually install windows collation
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
January 9, 2008 at 4:30 am
I am having the same issue.
The locale of my machine is United Kingdom. I think it is something to do with the locale not being United States.
I thinkCP1 specifies Code Page 1252, but I am not sure what that means exactly
I will try and let you know
January 9, 2008 at 4:50 am
Let me state what I am doing:-
Fresh install of SQL server 2000
Selecting custom installation
Selecting:-
Lattin1_General
Acent Sensitive
I cannot set the collation with the other option as AS is not available
Once the installation is completed, I can check the SQL server collation and it is set to LATIN1_GENERAL_CI_AS
I need it to be:-
LATIN1_GENERAL_CP1_CI_AS
January 9, 2008 at 6:25 am
OK, here is a quick update, I have managed to get this configured as per my requirements.
The locale has nothing to do with the collation settings that we need.
In order to get SQL_LATIN1_GENERAL_CP1_CI_AS
I had to select the following:-
'SQL Collations'
'Dictionary, case-insensitive, for use with 1252 character set'
I was initially sceptical as it did not mention Accent Sensitivity, but the server defaul seems to be AS.
I hope this helps any others with a similar issue.
regards,
Intersimi
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply