Collation
-
I want a collation of Western European
case-sensitive, accent-insensitive.
Which one should I pick in SQL Server 2000 Enterprise edition?
-
Maybe Latin1_General_CS_AI?
Latin1 is for Western European, and if I am understanding the nomenclature right on that abbreviation, CS = Case Sensitive and AI = Accent Insensitive.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley -
-
that does not exist guys.
-
If you are installing it and setting it for the server, select Collation designator (this is using the Windows collations) as opposed to SQL Collations. Choose Latin1_General and check only "Case sensitive."
The one I gave before was for an individual database, but it's the same setting.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley -
I am setting the collation at the database level.
The above suggestion does not exist correct?
-
The first one I gave exists at my database level. It's a Windows collation... so it's based on what is available for the OS.
If you go to Start | Settings | Control Panel | Regional Options do you have "Western Europe and United States" set as your default "Language settings for the system?"
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley -
no. Just "English(United States)"
-
That's the locale setting.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley -
ya thats the setting I have checked.
-
What are some of the options you are seeing?
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley -
It is actually there in the create database screen, collation name...
I was looking in Books Online and thats where it does not exist.
THANKS!!!
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply