Community AlphaAlpha MUADMINS
RORomână
Autentificare
Pe MuADMINSConfig ScannerÎncarcă zip-ul fișierelor tale: rate-uri, drop-uri, spoturi, limiteDeschidePe MuADMINSÎntâlnește-ne pe DiscordCere ajutor, arată la ce lucrezi și vorbește despre MU cu alți proprietari de servere.Deschide
← Toate soluțiile

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

Scris de MuADMINS pe baza surseiNot 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.

Scris de MuADMINS
Te-a ajutat?

Tot nu merge? Caută în MuGPS Întreabă Asistentul MU

MuADMINS Community Alpha: gratuit, făcut de comunitate, în dezvoltare activă.