April 22, 2009 at 1:49 am
Hi All, i am trying to install mssql2005 ent version 64bit. i get the default collation of the server as "SQL_Latin1_General_CP1_CI_AS" while as a requirement i need collation "Latin1_General_CI_AS". there was no such option the dropdown while installation.
could any one please tell me how to get the required collation of the server.
April 22, 2009 at 3:36 am
Hi Ritesh,
Collation can be set only during installation..u can change that during installation...
If u have already installed u need to uninstall and reinstall the server.
April 22, 2009 at 3:59 am
(step 1) You can change the collation, by changing it in the database properties, but ...
(step 2) all the tables in the database with varchar/char/nvarchar columns have the original collation. You can change this also (alter table ... alter column) but ...
in order to change this column, existing indexes on that column must be dropped first which can be a nasty one with primary/unique/referential keys.
I've attached a script to determine which columns don't have the database collation. (make sure @debug=1 to test it first). This scripts only gives results when the databasecollation columncollation.
Tip: you can force databasecollation in procedures by using [c]COLLATE DATABASE_DEFAULT[/b] see BOL
Wilfred
The best things in life are the simple things
April 22, 2009 at 4:01 am
Sorry, my answer is for user databases, I didn't read your question quite well. So my answer is for user databases with a different collation.
BTW you can create a database with a different collation compared to the server collation
Wilfred
The best things in life are the simple things
April 22, 2009 at 4:31 am
Hello Ritesh,
Your question is to set the default collation "Latin1_General_CI_AS".
First Uninstall the sql server and reinstall it:
Whiel reinstalling in the collation settings select following options:
Select Radio button "Collation designator and sort order:"
Select from drop down "Latin1_General"
Select Check box "Accent-sensitive"
and complete the installation.
Cheers!
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
April 22, 2009 at 5:15 am
Thanks Ratheesh.You are great.:-P
[font="Comic Sans MS"]+++BLADE+++[/font]:cool:
April 22, 2009 at 6:01 am
yes, thats true but again while installation what should be the setting to achieve the collation. because there is no straight forward collation as "Latin1_General_CI_AS". In the dropdown while installation i got only "Latin1_General" as the options and there were some check boxes too. Could please guide me to configuration i should choose to achieve the wanted.
April 22, 2009 at 6:09 am
Thanks a lot that was the exact answer i required......
April 22, 2009 at 6:10 am
Do as free_mascot said...
CI for case Insensitive and AS accent sensitive
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply