SQL collation names - used for setting up SQL server for minisap
Below is a list of collation names available for the SQL server 2000 setup.exe COLLATE parameter available on
the microsoft site
Key for collation names
CI specifies case-insensitive
CS specifies case-sensitive.
AI specifies accent-insensitive
AS specifies accent-sensitive.
BIN specifies the binary sort order is to be used.
SQL collation name
SQL_Latin1_General_Cp437_BIN
SQL_Latin1_General_Cp437_CS_AS
SQL_Latin1_General_Cp437_CI_AS
SQL_Latin1_General_Pref_CP437_CI_AS
SQL_Latin1_General_Cp437_CI_AI
SQL_Latin1_General_Cp850_BIN
SQL_Latin1_General_Cp850_CS_AS
SQL_Latin1_General_Cp850_CI_AS
SQL_Latin1_General_Pref_CP850_CI_AS
SQL_Latin1_General_Cp850_CI_AI
SQL_1Xcompat_CP850_CI_AS
Latin1_General_BIN
SQL_Latin1_General_Cp1_CS_AS
SQL_Latin1_General_Cp1_CI_AS
SQL_Latin1_General_Pref_CP1_CI_AS
SQL_Latin1_General_Cp1_CI_AI
SQL_AltDiction_Cp850_CS_AS
SQL_AltDiction_Pref_CP850_CI_AS
SQL_AltDiction_Cp850_CI_AI
SQL_Scandinavian_Pref_Cp850_CI_AS
SQL_Scandinavian_Cp850_CS_AS
SQL_Scandinavian_Cp850_CI_AS
SQL_AltDiction_Cp850_CI_AS
Latin1_General_CS_AS
Latin1_General_CI_AS
Danish_Norwegian_CS_AS
Finnish_Swedish_CS_AS
Icelandic_CS_AS
Hungarian_BIN (or Albanian_BIN, Czech_BIN, and so on)1
SQL_Latin1_General_Cp1250_CS_AS
SQL_Latin1_General_Cp1250_CI_AS
SQL_Czech_Cp1250_CS_AS
SQL_Czech_Cp1250_CI_AS
SQL_Hungarian_Cp1250_CS_AS
SQL_Hungarian_Cp1250_CI_AS
SQL_Polish_Cp1250_CS_AS
SQL_Polish_Cp1250_CI_AS
SQL_Romanian_Cp1250_CS_AS
SQL_Romanian_Cp1250_CI_AS
SQL_Croatian_Cp1250_CS_AS
SQL_Croatian_Cp1250_CI_AS
SQL_Slovak_Cp1250_CS_AS
SQL_Slovak_Cp1250_CI_AS
SQL_Slovenian_Cp1250_CS_AS
SQL_Slovenian_Cp1250_CI_AS
Cyrillic_General_BIN (or Ukrainian_BIN, Macedonian_BIN)
SQL_Latin1_General_Cp1251_CS_AS
SQL_Latin1_General_Cp1251_CI_AS
SQL_Ukrainian_Cp1251_CS_AS
SQL_Ukrainian_Cp1251_CI_AS
Greek_BIN
SQL_Latin1_General_Cp1253_CS_AS
SQL_Latin1_General_Cp1253_CI_AS
SQL_MixDiction_Cp1253_CS_AS
SQL_AltDiction_Cp1253_CS_AS
SQL_Latin1_General_Cp1253_CI_AI
Turkish_BIN
SQL_Latin1_General_Cp1254_CS_AS
SQL_Latin1_General_Cp1254_CI_AS
Hebrew_BIN
SQL_Latin1_General_Cp1255_CS_AS
SQL_Latin1_General_Cp1255_CI_AS
Arabic_BIN
SQL_Latin1_General_Cp1256_CS_AS
SQL_Latin1_General_Cp1256_CI_AS
SQL_Latin1_General_Cp1257_CS_AS
SQL_Latin1_General_Cp1257_CI_AS
SQL_Estonian_Cp1257_CS_AS
SQL_Estonian_Cp1257_CI_AS
SQL_Latvian_Cp1257_CS_AS
SQL_Latvian_Cp1257_CI_AS
SQL_Lithuanian_Cp1257_CS_AS
SQL_Lithuanian_Cp1257_CI_AS
SQL_Danish_Pref_Cp1_CI_AS
SQL_SwedishPhone_Pref_Cp1_CI_AS
SQL_SwedishStd_Pref_Cp1_CI_AS
SQL_Icelandic_Pref_Cp1_CI_AS
Japanese_BIN
Japanese_CI_AS
Korean_Wansung_BIN
Korean_Wansung_CI_AS
Chinese_Taiwan_Stroke_BIN
Chinese_Taiwan_Stroke_CI_AS
Chinese_PRC_BIN
Chinese_PRC_CI_AS
Japanese_CS_AS
Korean_Wansung_CS_AS
Chinese_Taiwan_Stroke_CS_AS
Chinese_PRC_CS_AS
Thai_BIN
Thai_CI_AS
Thai_CS_AS
SQL_EBCDIC037_CP1_CS_AS
SQL_EBCDIC273_CP1_CS_AS
SQL_EBCDIC277_CP1_CS_AS
SQL_EBCDIC278_CP1_CS_AS
SQL_EBCDIC280_CP1_CS_AS
SQL_EBCDIC284_CP1_CS_AS
216 SQL_EBCDIC285_CP1_CS_AS
SQL_EBCDIC297_CP1_CS_AS
Website Navigation to related information
|
