[Antosh]

Hi, i have a problem with saving custom nicknames from player to database. If user has a nick like:


or


Database displays question marks.

Charset:

SQL_SetCharset(g_hDB, "utf8mb4");

how could i fix it?

[L4D2Noob]

Originally Posted by Antosh utf8mb4

Try saving nicknames in utf8mb4_bin encoding

[Antosh]

Originally Posted by L4D2Noob Try saving nicknames in utf8mb4_bin encoding

Now is:

[Marttt]

you nickname column should be nvarchar type as well and the database collation should allow this kind of nick name.
Did you test manually inserting the nickname in database? (SQL: INSERT <nickname> INTO table)

[Antosh]

Now it works in db



but on website (the page retrieves data from this db) still are question marks

im using on web: <meta charset="utf-8" /> should i change it? no idea...