By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,574 Members | 1,968 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,574 IT Pros & Developers. It's quick & easy.

SQL_Latin1_General_CP1_CS_AS

P: n/a
When installing SQL server default is 'dictionary order
case-insensitve..1250..', however I chose dictionary order case-SENSITIVE
from the SQL collation. At the top window there are'Latin1_General' with the
option of case-sensitive, where you also see BINARY etc...

Is there any difference between SQL_Latin1_General_CP1_CS_AS select from
lower window and 'Latin1_General' select with case-sensitive from the upper
window?

TIA,
Nasir
Jun 2 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Nasir (nm*****@prosrm.com) writes:
When installing SQL server default is 'dictionary order
case-insensitve..1250..', however I chose dictionary order
case-SENSITIVE from the SQL collation. At the top window there
are'Latin1_General' with the option of case-sensitive, where you also
see BINARY etc...

Is there any difference between SQL_Latin1_General_CP1_CS_AS select
from lower window and 'Latin1_General' select with case-sensitive from
the upper window?


Yes, there are differences. One is an SQL collation, the other is a
Windows collation.

SQL Collations are SQL Server's own collations and represent a legacy
from the time, when SQL Server defined its sort orders on its own.
Windows collations on the other hand are taken from Windows.

When you install SQL Server, you will be suggested a default collation
depending on the system locale. I believe that for most settings you will
be suggested a Windows collations. For instance, in my case, I am
proposed Finnish_SwedishŚ_CI_AS (which I promptly change to CS_AS). But
there is at least one exception: if your system locale is US English,
you will be suggested SQL_Latin1_General_CP1_CI_AS.

So what is the difference then? Ehum, I will have to admit that I am a
little foggy on the details, but the difference is mainly in how
punctuation characters and digits are sorted.

I would recommend using a Windows collation.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx
Jun 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.