Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server > Shaiya PServer Guides & Releases
[Release] change database language SQL script [Release] change database language SQL script
You last visited: Today at 23:49

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

[Release] change database language SQL script

Discussion on [Release] change database language SQL script within the Shaiya PServer Guides & Releases forum part of the Shaiya Private Server category.

Reply
 
Old   #1
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Mar 2011
Posts: 51
Received Thanks: 30
[Release] change database language SQL script

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

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
andya78 is offline  
Thanks
6 Users
Reply

« [Release]How to do Web register | [Release] (Incompleted) Django/Python server management files »

Similar Threads Similar Threads
[Release]CLEAN database + MSSQL cleaning script
11/02/2020 - Dekaron Private Server - 31 Replies
My 666th post! Ok, so I know everyone is expecting the IPbanV2/3 from me as my next release, but I decided I will do this first, because it took me a lot less time. LINK (megaupload) ALL info is deleted, except what is required to run the server with all functions like in the silkbotter's database. Tested by myself, and working. NOTE: Siege is not added, but you can add it easily with the script. I didn't add siege, because I thought that you will want to set the start time like you...
[RELEASE] Secure PHP Web Change Password Script
08/28/2013 - Shaiya PServer Guides & Releases - 8 Replies
This is a secure password change script meant for Shaiya private servers. I noticed a lot of private servers do not allow regular users to change passwords. Be warned, this script is a double-edged sword in a way, ESPECIALLY since most servers do not allow for password recovery via email or some other method. By implementing this script players who have shared their account credentials with other players can now get their password changed unknowingly (and thus their account is now...
[SEA]Small database change
05/23/2010 - SRO PServer Guides & Releases - 13 Replies
Changed all items in NPC To seal of sun, and return scrolls to globals DL Link: Database.rar Buy items, Teleport and they are converted to whatever you bought i will upload a media pk2 so this isnt neccesary later, with these items in the npcs
[Release] PSC Database Script
02/27/2010 - Metin2 PServer Guides & Strategies - 56 Replies
Hallo, ich hatte langeweile und hab euch mal ein Paysafecard-Script geschrieben, das die Accountid und die Paysafecard-Nummer in der Database speichert ;) Es ist nichts besonderes aber könnte anderen helfen. Anleitung: Die config.php in dem Ordner 'inc' anpassen. Die install.php im Ordner 'install' über xampp/webspace oder sonstiges ausführen (Xampp: http://localhost/install/install.php) Danach könnt ihr das Script benutzen ;) MFG P.S. Datei im Anhang!
[wanted Release] Change Password Script (with recapcha and working)
01/10/2010 - EO PServer Hosting - 7 Replies
well guys a lot of persones want this kind of script and here it is then it worked for me and now you can use it to and if i can ask please leave credits or give atleast a thank you for fixing it :P please note :



All times are GMT +2. The time now is 23:49.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.