BlancO
19th November 2013, 22:21
Hello,
I've got a problem with players' names on server. I want to store them in MySQL DB. Connection works nice. I save it without problems. But I can't read/select including special chatacters.
I have written debug to check, whats wrong.
Normally I got this:
guid=123456 score=0 name=Unnamed Player
But when player has special characters in his name:
^33×YankeS×^2Ž
PHP reads his name as:
^^00Gumowy#^2Š^^33×YankeS×^2Ž
The real nickname is:
540
MySQL query:
SELECT `guid`, `score`, `last_nick` FROM players WHERE `guid`='xxxxxx'
How can I read special characters from MySQL?
I've got a problem with players' names on server. I want to store them in MySQL DB. Connection works nice. I save it without problems. But I can't read/select including special chatacters.
I have written debug to check, whats wrong.
Normally I got this:
guid=123456 score=0 name=Unnamed Player
But when player has special characters in his name:
^33×YankeS×^2Ž
PHP reads his name as:
^^00Gumowy#^2Š^^33×YankeS×^2Ž
The real nickname is:
540
MySQL query:
SELECT `guid`, `score`, `last_nick` FROM players WHERE `guid`='xxxxxx'
How can I read special characters from MySQL?