live-chat
Email

Intellect Connect

Change the Collation of your Database

You can use the following query in Enterprise Manager or Management Studios against an SQL 2000 or 2005 database to change the collation:

USE Tempdb
GO
ALTER DATABASE (database name here) COLLATE (collation name here)
GO

(Note: remove parenthesis for database name and collation name)

Collation names:

(Language = Collation)

Afrikaans = Latin1_General_CI_AS

Albanian = Albanian_CI_AS

Arabic (Algeria) = Arabic_CI_AS

Arabic (Bahrain) = Arabic_CI_AS

Arabic (Egypt) = Arabic_CI_AS

Arabic (Iraq) = Arabic_CI_AS

Arabic (Jordan) = Arabic_CI_AS

Arabic (Kuwait) = Arabic_CI_AS

Arabic (Lebanon) = Arabic_CI_AS

Arabic (Libya) = Arabic_CI_AS

Arabic (Morocco) = Arabic_CI_AS

Arabic (Oman) = Arabic_CI_AS

Arabic (Qatar) = Arabic_CI_AS

Arabic (Saudi Arabia) = Arabic_CI_AS

Arabic (Syria) = Arabic_CI_AS

Arabic (Tunisia) = Arabic_CI_AS

Arabic (U.A.E.) = Arabic_CI_AS

Arabic (Yemen) = Arabic_CI_AS

Armenian (Republic of Armenia) = Latin1_General_CI_AS

Azeri-Cyrillic (Azerbaijan)1 = Azeri_Cyrillic_90_CI_AS

Azeri-Latin (Azerbaijan)1 = Azeri_Latin_90_CI_AS

Basque = Latin1_General_CI_AS

Belarusian = Cyrillic_General_CI_AS

Bulgarian = Cyrillic_General_CI_AS

Catalan = Latin1_General_CI_AS

Chinese (Hong Kong S.A.R.)1 = Chinese_Hong_Kong_Stroke_90_CI_AS

Chinese (Macau S.A.R.)2 = Chinese_PRC_90_CI_AS

Chinese (PRC)2 = Chinese_PRC_CI_AS

Chinese (PRC) = Chinese_PRC_Stroke_CI_AS

Chinese (Singapore) = Chinese_PRC_90_CI_AS

Chinese (Taiwan) = Chinese_Taiwan_Stroke_CI_AS

Chinese (Taiwan) = Chinese_Taiwan_Bopomofo_CI_AS

Croatian = Croatian_CI_AS

Czech = Czech_CI_AS

Danish = Danish_Norwegian_CI_AS

Divehi1 = Divehi_90_CI_AS (Unicode only)

Dutch (Belgium) = Latin1_General_CI_AS

Dutch (Netherlands) = Latin1_General_CI_AS

English (Australia) = Latin1_General_CI_AS

English (Belize) = Latin1_General_CI_AS

English (Canada) = Latin1_General_CI_AS

English (Caribbean) = Latin1_General_CI_AS

English (Hong Kong S.A.R.) = Latin1_General_CI_AS

English (India) = Latin1_General_CI_AS

English (Indonesia) = Latin1_General_CI_AS

English (Ireland) = Latin1_General_CI_AS

English (Jamaica) = Latin1_General_CI_AS

English (Malaysia) = Latin1_General_CI_AS

English (New Zealand) = Latin1_General_CI_AS

English (Philippines) = Latin1_General_CI_AS

English (Singapore) = Latin1_General_CI_AS

English (South Africa) = Latin1_General_CI_AS

English (Trinidad) = Latin1_General_CI_AS

English (United Kingdom) = Latin1_General_CI_AS

English (United States) = SQL_Latin1_General_CP1_CI_AS

English (Zimbabwe) = Latin1_General_CI_AS

Estonian = Estonian_CI_AS

Faeroese = Latin1_General_CI_AS

Farsi = Arabic_CI_AS

Finnish = Finnish_Swedish_CI_AS

French (Belgium) = French_CI_AS

French (Canada) = French_CI_AS

French (France) = French_CI_AS

French (Luxembourg) = French_CI_AS

French (Monaco) = French_CI_AS

French (Switzerland) = French_CI_AS

Galician (Spain) = Latin1_General_CI_AS

Georgian = Latin1_General_CI_AS

German (Austria) = Latin1_General_CI_AS

German (Germany) = Latin1_General_CI_AS

German (Liechtenstein) = Latin1_General_CI_AS

German (Luxembourg) = Latin1_General_CI_AS

German (Phone Book Sort) = German_PhoneBook_CI_AS

German (Switzerland) = Latin1_General_CI_AS

Greek = Greek_CI_AS

Gujarati (India)3 = Indic_General_90_CI_AS (Unicode only)

Hebrew = Hebrew_CI_AS

Hindi3 = Indic_General_90_CI_AS (Unicode only)

Hungarian = Hungarian_CI_AS

Hungarian (Technical) = Hungarian_Technical_CI_AS

Icelandic = Icelandic_CI_AS

Indonesian = Latin1_General_CI_AS

Italian (Italy) = Latin1_General_CI_AS

Italian (Switzerland) = Latin1_General_CI_AS

Japanese = Japanese_CI_AS

Kannada (India)3 = Indic_General_90_CI_AS (Unicode only)

Kazakh (Kazakstan)1 = Kazakh_90_CI_AS

Konkani (India)3 = Indic_General_90_CI_AS (Unicode only)

Korean (Extended Wansung) = Korean_Wansung_CI_AS

Kyrgyz-Cyrillic (Republic of Kyrgyztan) = Cyrillic_General_CI_AS

Latvian = Latvian_CI_AS

Lithuanian = Lithuanian_CI_AS

Macedonian (FYROM) = Macedonian_FYROM_90_CI_AS

Malay (Brunei Darussalam) = Latin1_General_CI_AS

Malay (Malaysia) = Latin1_General_CI_AS

Marathi (India)3 = Indic_General_90_CI_AS (Unicode only)

Mongolian-Cyrillic (Mongolia) = Cyrillic_General_CI_AS

Norwegian (Bokmal) = Danish_Norwegian_CI_AS

Norwegian (Nynorsk) = Danish_Norwegian_CI_AS

Polish = Polish_CI_AS

Portuguese (Brazil) = Latin1_General_CI_AS

Portuguese (Portugal) = Latin1_General_CI_AS

Punjab-Gurmuhki (India)3 = Indic_General_90_CI_AS (Unicode only)

Romanian = Romanian_CI_AS

Russian = Cyrillic_General_CI_AS

Sanskrit (India)3 = Indic_General_90_CI_AS (Unicode only)

Serbian (Cyrillic) = Cyrillic_General_CI_AS

Serbian (Latin) = Cyrillic_General_CI_AS

Slovak = Slovak_CI_AS

Slovenian = Slovenian_CI_AS

Spanish (Argentina) = Modern_Spanish_CI_AS

Spanish (Bolivia) = Modern_Spanish_CI_AS

Spanish (Chile) = Modern_Spanish_CI_AS

Spanish (Colombia) = Modern_Spanish_CI_AS

Spanish (Costa Rica) = Modern_Spanish_CI_AS

Spanish (Dominican Republic) = Modern_Spanish_CI_AS

Spanish (Ecuador) = Modern_Spanish_CI_AS

Spanish (El Salvador) = Modern_Spanish_CI_AS

Spanish (Guatemala) = Modern_Spanish_CI_AS

Spanish (Honduras) = Modern_Spanish_CI_AS

Spanish (International Sort) = Modern_Spanish_CI_AS

Spanish (Mexico) = Modern_Spanish_CI_AS

Spanish (Nicaragua) = Modern_Spanish_CI_AS

Spanish (Panama) = Modern_Spanish_CI_AS

Spanish (Paraguay) = Modern_Spanish_CI_AS

Spanish (Peru) = Modern_Spanish_CI_AS

Spanish (Puerto Rico) = Modern_Spanish_CI_AS

Spanish (Traditional Sort) = Traditional_Spanish_CI_AS

Spanish (Uruguay) = Modern_Spanish_CI_AS

Spanish (Venezuela) = Modern_Spanish_CI_AS

Swahili = Latin1_General_CI_AS

Swedish = Finnish_Swedish_CI_AS

Swedish (Finland) = Finnish_Swedish_CI_AS

Syriac (Syria)1 = Syriac_90_CI_AS (Unicode only)

Tamil (India)1 = Indic_General_90_CI_AS (Unicode only)

Tatar (Tatarstan)1 = Tatar_90_CI_AS

Telugu (India)1 = Indic_General_90_CI_AS (Unicode only)

Thai = Thai_CI_AS

Turkish = Turkish_CI_AS

Ukrainian = Ukrainian_CI_AS

Urdu = Arabic_CI_AS

Uzbek (Latin)1 = Uzbek_Latin_90_CI_AS

Uzbek-Cyrillic (Republic of Uzbeckistan) = Cyrillic_General_CI_AS

Vietnamese = Vietnamese_CI_AS


Interested in letting our experts solve your IT problems for you? Get a free, no-obligations consultation with one of our experts today!
Chat Now!, Contact Us , Or call us at (855) 850-HOST

footer-logos