Community AlphaAlpha MUADMINS
TRTürkçe
Giriş yap
MuADMINS'teConfig ScannerDosyalarının zip'ini yükle: rate'ler, droplar, spotlar, limitlerAçMuADMINS'teDiscord'da buluşalımYardım iste, üzerinde çalıştığın şeyleri paylaş ve diğer sunucu sahipleriyle MU hakkında konuş.Aç
← Tüm çözümler

Korean, Cyrillic, Greek or other character names turn into ?? (collation and Unicode in MU databases)

Kaynaktan yola çıkılarak MuADMINS tarafından yazıldıNot verified

In every MSSQL files family we read, names are VARCHAR: Character.Name varchar(10), AccountCharacter.GameID1 ... varchar(10), Guild.G_Name varchar(8), MEMB_INFO.memb___id varchar(10). A VARCHAR column stores text in the code page of its collation. IGCN CreateDatabase.sql creates all databases with COLLATE SQL_Latin1_General_CP1_CI_AS (Latin code page) and the IGCN Season 9 script even sets that collation on 116 columns: any letter outside that code page is saved as ?.

  1. See what you have:
SELECT name, collation_name FROM sys.databases;
SELECT COLUMN_NAME, COLLATION_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'Character' AND COLUMN_NAME = 'Name';
  1. New server: create the empty database with the collation of your language before running the pack scripts (for Korean for example Korean_Wansung_CI_AS), and keep it case insensitive (_CI_, the IGCN documentation asks for it). With a double byte code page each Korean letter uses 2 of the 10 bytes, so names are 5 letters at most.
  2. Existing server: changing VARCHAR to NVARCHAR is a big migration (see the Unicode migration review). Whether the game then shows the names correctly is decided by the server files and the client, not by SQL: test with one name on a copy first.
  3. Website and game databases with different collations give "Cannot resolve the collation conflict" errors; DmN's procedures avoid it with COLLATE Database_Default in their comparisons.

Source: IGCN S16 / S17 / S18 CreateDatabase.sql, IGCN S9 MuOnline(MD5).sql (116 COLLATE clauses), Character / AccountCharacter / Guild definitions in the IGCN, X-Team, MuDevs scripts, DmN CMS 1.2.3 procedures.

MuADMINS tarafından yazıldı
Bu işinize yaradı mı?

Hâlâ takıldınız mı? MuGPS'te ara MU Asistanı'na sor

MuADMINS Community Alpha: ücretsiz, topluluk tarafından yapılıyor, aktif geliştirmede.