collations 1

[shanghai2004]

Dear Expert,

What is the different between SQL_Latin1_General_Cp1_CI_AS and Latin1_General_CI_AS ? What does Cp1 represent for? Where do I find this kind information? I searched from SQL help, but I did not find the answer. Help please!

Happy New Year

 

[SQLDenis]

run this in QA

SELECT *
FROM ::fn_helpcollations()


Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLDenis]

So basically this is the difference

Latin1_General_CI_AS
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive

SQL_Latin1_General_CP1_CI_AS
Latin1-General, case-insensitive, accent-sensitive, kanatype-insensitive, width-insensitive for Unicode Data, SQL Server Sort Order 52 on Code Page 1252 for non-Unicode Data

SELECT *
FROM ::fn_helpcollations()
where name in ('SQL_Latin1_General_Cp1_CI_AS','Latin1_General_CI_AS')

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/