delight-im / OpenSoccer

[UNMAINTAINED] Online Soccer Manager
GNU General Public License v3.0
52 stars 25 forks source link

data.sql UTF-8 #328

Closed bornhaeusser closed 8 years ago

bornhaeusser commented 8 years ago

Short Question is the data.sql sett corect to utf8? because the "Umalaute" are wrong (ä,ü,ö,etc)

ocram commented 8 years ago

Well, it's certainly not the way the characters should be in the database, but it's what has always been working. So this has been kept around.

When it comes to UTF-8 storage and output:

So there is no reason not to use UTF-8 everywhere, actually. But again, this is what has always been working.

If it doesn't work for you, maybe you have to adjust the charset for the database connection in zzserver.php, e.g. using:

mysql_set_charset('latin1');
// or
mysql_set_charset('utf8');

Perhaps that helps. Otherwise, feel free to convert your database encoding (especially the encoding of the import files) as you like. Anyway, it's definitely possible to make the import work with the current setup and the import files as they are.