[Help] Character Enconting

[littlechris95]

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):

 Spoiler

[InsomniacPro]

Try utilizing nvarchar instead.

[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.

[littlechris95]

Originally Posted by InsomniacPro

Try utilizing nvarchar instead.

MySql does not support this type of attribute :/

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?

[CptSky]

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.

[littlechris95]

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

[Spirited]

Closed as requested.