CODEWITHSUNDEEP
sql-servert-sql
htm11h
htm11h

Reputation: 1779

Collation abbreviation, not sure of meaning

UPDATE: Running this:

 ALTER DATABASE "STRINGSDB.MDF"
    COLLATE Latin1_General_CS_AShere

Getting this error:

Msg 5030, Level 16, State 2, Line 1 The database could not be exclusively locked to perform the operation. Msg 5072, Level 16, State 1, Line 1 ALTER DATABASE failed. The default collation of database 'STRINGSDB.MDF' cannot be set to Latin1_General_CS_AS.

I only have SQL server Management Studio accessing the DB.

ORIGINAL POST:

My SQLEE indicates a Collation of... COLLATE SQL_Latin1_General_CP1_CS_AS

I am having problems finding the meaning of the CP1, does anyone know what this means?

I also ran...

select * from ::fn_helpcollations()

and the SQL_Latin1_General_CP1_CS_AS doesn't exist, also checked... Latin1_General_CP1_CS_AS

thanks for any help.

Upvotes: 0

Views: 1500

Answers (1)

Oded
Oded

Reputation: 498904

From SQL Server Collation Name (Transact-SQL):

CP1 specifies code page 1252

Upvotes: 2

Related Questions