csgo-multi-1v1 icon indicating copy to clipboard operation
csgo-multi-1v1 copied to clipboard

Name saved in database don't support all UTF-8 Chars

Open bojank opened this issue 10 years ago • 1 comments

Hey Splewis I noticed the way the name is saved into database now was changed and its saved as a UTF-8. MySQL's way of storing utf-8 actually uses 3 bytes as oppose to the 4 needed so some characters that people like to use in their names get changed to ? I was wondering if it can be changed back to the old way of storing them. or setting up the database to use utf8mb4 instead of utf8

Heres a article which explains how to fully support utf8 in mysql https://mathiasbynens.be/notes/mysql-utf8mb4

Thanks Splewis

bojank avatar Feb 22 '15 17:02 bojank

I would like to know if you already have any fix for this BUG.

My server started to issue the error in my server error logs:

L 02/13/2019 - 12:40:22: [multi1v1.smx] Last SQL Error: Incorrect string value: '\xF0\x9F\x8C\x90\xE2\x98...' for column 'name' at row 1
L 02/13/2019 - 12:43:06: [multi1v1.smx] Last SQL Error: Incorrect string value: '\xE9\xA3\x9B\xE5\xA4\xA9...' for column 'name' at row 1
L 02/13/2019 - 12:44:51: [multi1v1.smx] Last SQL Error: Incorrect string value: '\xF0\x9F\x8C\x90\xE2\x98...' for column 'name' at row 1
L 02/13/2019 - 12:48:02: [multi1v1.smx] Last SQL Error: Incorrect string value: '\xE2\x9C\xAA Ha...' for column 'name' at row 1
L 02/13/2019 - 12:48:52: [multi1v1.smx] Last SQL Error: Incorrect string value: '\xE2\x98\xA0 Te...' for column 'name' at row 1
L 02/13/2019 - 12:50:11: [multi1v1.smx] Last SQL Error: Incorrect string value: '\xCA\x9C\xC9\xA2' for column 'name' at row 1
L 02/13/2019 - 12:53:01: [multi1v1.smx] Last SQL Error: Incorrect string value: '\xE2\x98\xA0 Te...' for column 'name' at row 1
L 02/13/2019 - 12:53:50: [multi1v1.smx] Last SQL Error: Incorrect string value: '\xCA\x9C\xC9\xA2' for column 'name' at row 1

Full error log: errors_20190213.log

crashzk avatar Feb 13 '19 17:02 crashzk