csgo-multi-1v1
csgo-multi-1v1 copied to clipboard
Name saved in database don't support all UTF-8 Chars
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
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