What is CP1 in SQL_Latin1_General_CP1_CI_AI?
CP1 denotes code page 1252 as described in the SQL Server Books Online.  You can also use the query below to identify the collation code page.

SELECT name, COLLATIONPROPERTY(name, 'CodePage') AS CodePage
FROM fn_helpcollations()
ORDER BY name;