August 6, 2009 at 2:45 am
Hi,
I'm always installing SQL Server 2005 with the default collation settings "SQL_Latin1_General_CP1_CI_AS". I want to know what you guys do? go with default collations or something else?
I know that it depends on the application, but if the application did not required any special type of collation settings then what you will choose?
August 6, 2009 at 3:44 am
We are using "Latin1_General_CI_AI" 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
August 6, 2009 at 6:55 am
We mostly use "SQL_Latin1_General_CP1_CI_AS" but we have some applications that require different. It's really depending on the requirements of the application what you would have....
August 6, 2009 at 7:03 am
It also depends on the place of living. For example in Israel there is a need to store Hebrew characters without using Unicode, so you can find servers that use the windows collation Hebrew_CI_AS or the SQL Server collation SQL_Latin1_General_Cp1254_CI_AS. I don’t think that you’ll find many server that are configured to one of those collations outside of Israel:-). Of course there are other countries that have there own collations
Adi
--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply