SQL Server 2008 collation question

Hi !

What is the difference between Latin1_General and Latin1_General_100 and Latin1_General_BIN

Thank you.
Rubicon2009Asked:
Who is Participating?
 
ValentinoVBI ConsultantCommented:
jogos: I think you meant the following (there's a "1" missing in the collation name):

SELECT * , COLLATIONPROPERTY(name, 'version') version
,COLLATIONPROPERTY(name, 'LCID') lcid
,COLLATIONPROPERTY(name, 'ComparisonStyle') ComparisonStyle
,COLLATIONPROPERTY(name, 'version') vercion
FROM fn_helpcollations()
where name like 'Latin1_General%'
order by name

Open in new window

0
 
jogosCommented:
Check out the properties of the collation http://msdn.microsoft.com/en-us/library/ms190305(v=sql.105).aspx

SELECT * , COLLATIONPROPERTY(name, 'version') version
,COLLATIONPROPERTY(name, 'LCID') lcid
,COLLATIONPROPERTY(name, 'ComparisonStyle') ComparisonStyle
,COLLATIONPROPERTY(name, 'version') vercion
FROM fn_helpcollations()
where name like 'Latin_General%'
order by name

Open in new window

0
 
ValentinoVBI ConsultantCommented:
Latin1_General_BIN is a binary collation:

"Binary collations sort data based on the sequence of coded values that are defined by the locale and data type. They are case sensitive. A binary collation in SQL Server defines the locale and the ANSI code page that will be used. This enforces a binary sort order. Because they are relatively simple, binary collations help improve application performance. (contd)"
(ref. http://msdn.microsoft.com/en-us/library/ms143726.aspx)

Latin1_General_100 is a _100 level collation:

"All _100 level collations support linguistic sorting with supplementary characters." - see the chapter called Supplementary Characters in the reference above
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.