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