Does TS3 write Latin1 Strings into UTF8 Mysql-DB?

[seriouz]

Hi,

i have the feeling, that TS3 writes Latin1 encoded Strings into the UTF8 MySQL DB.
Because, when i open a table with SQLyog or get a row with php. The strings are not
in UTF8 chars, but Latin1!

Attachment 4624

Thanks

[dante696]

TS writes UTF8 into your databse, but Latin1 is a MYSQL setting from your database.

[QweSteR]

Hi, what should I do to have UTF-8 encoded data in my MySQL database?
The DB uses utf8_general_ci collation. And here are some variables:

character_set_client 	        utf8
character_set_connection 	utf8
character_set_filesystem 	binary
character_set_results 	        utf8
character_set_system 	        utf8
collation_connection 	        utf8_general_ci

[SilentStorm]

when using PHP make sure to set the Connection Encoding to UTF8 before writing / selecting anything from the Database.

http://de3.php.net/manual/en/mysqli....r-set-name.php
http://de3.php.net/mysql_set_charset

[QweSteR]

Yes, I know it. But in my case I use

mysql_set_charset('cp1251');

to get text in normal view. If I use

mysql_set_charset('utf8');

I have non-correct text. I don't know what's wrong with the db, any ideas?
How can I understand what charset/collation is used by TS3 server?

[SilentStorm]

You have incorrect Text where? When you output it to the browser?
If so keep in mind that you also need to send a Content-Type header in order to specify the Charset to be used by the browser, which will otherwise use whatever the system's default is (which obviously varies in different parts of the world).

The Database Tables and Fields should all be utf8 and the entire Server & Client are using and expecting UTF8 encoded Strings all over the place.

[QweSteR]

I use binary encoding to solve the problem. Using UTF-8 saves data incorrectly at the database.