Solved

SQL Server 2008 collation question

Posted on 2012-04-12
3
1,262 Views
Last Modified: 2012-05-17
Hi !

What is the difference between Latin1_General and Latin1_General_100 and Latin1_General_BIN

Thank you.
0
Comment
Question by:Rubicon2009
  • 2
3 Comments
 
LVL 25

Assisted Solution

by:jogos
jogos earned 167 total points
ID: 37841618
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
 
LVL 37

Assisted Solution

by:ValentinoV
ValentinoV earned 333 total points
ID: 37841691
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
 
LVL 37

Accepted Solution

by:
ValentinoV earned 333 total points
ID: 37841696
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

Featured Post

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question