[CoD2] [MySQL] [libcod] Special characters

[BlancO]

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:


MySQL query:

		SELECT `guid`, `score`, `last_nick` FROM players WHERE `guid`='xxxxxx' 
	

How can I read special characters from MySQL?