difference between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS

[dav...@gmail.com]

Does anyone know the difference between
SQL_Latin1_General_CP1_CI_AS
and
Latin1_General_CI_AS
?

what is purpose of CP1?

Can you mix these collations on a sql 2005 database with no issues?

[amish]

I think CP1 stands for code page. I got the idea by comparing
descriptions from the result.

select * from fn_helpcollations()
where name like '%SQL_Latin1_General_CP1_CI_AS%'
or name = 'Latin1_General_CI_AS'
or name like '%cp1%'

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

you can get more idea from fn_helpcollations.