[Help] Character Enconting

Hello everybody! I have a little problem with my database (MySQL), the problem is in character enconding ... When I create an account with this character "†" it is not saved in the database, and the funny thing is that in the game he aprece normally.

For a better understanding (Photos):

Try utilizing nvarchar instead.

You shouldn't use UTF-8 with CO2 as surrogates pairs won't be converted properly when shown in CP-1252, by the client.

Quote:

Originally Posted by InsomniacPro Try utilizing nvarchar instead.

MySql does not support this type of attribute :/

Quote:

Originally Posted by CptSky You shouldn't use UTF-8 with CO2 as surrogates pairs won't be converted properly when shown in CP-1252, by the client.

Which should I use? That players can use special characters without any problem?

Quote:

Originally Posted by littlechris95 Which should I use? That players can use special characters without any problem?

The client uses CP-1252. latin1_swedish_ci should be fine in MySQL.

Quote:

Originally Posted by CptSky The client uses CP-1252. latin1_swedish_ci should be fine in MySQL.

I'll try this, but the source and which one should I use? UTF7? ASCII?

I got it!

Thanks to everyone and especially to Abdou <3

#Request Close

Closed as requested.