Followup to collation question

[Al]

I'm searching the Books Online but can't (as yet) discover the difference between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS. CP1 is code page 1252, but what's the 'default' if I don't specify CP1?

Thanks,

Al

[solart]

A typical SQL 2000 installation defaults to the following for a collation sequence:

SQL_Latin1_General_CP1_CI_AS

Meaning code page 1252, case-insentitive, accent sentitive.

In order to pick another collation sequence, you must select the custom install.

HTHs solart

[ClayG]

The default SQL2000 code page for a CLEAN install is different to what you get from upgrading SQL7. I think these are the two collations you mentioned. I think the CP1 is SQL7.

BOL SORT OF says it.

Collations are generally identified by a collation name. There are two classes of names: Windows collation names for the new collations aligned with Windows locales, and SQL collation names for the compatibility mode collations that result when upgrading from earlier versions of SQL Server. For more information, see Windows Collation Name), and SQL Collation Name.

Also:

http://www.microsoft.com/sql/techinf...ngcodepage.asp