Quote:
Originally Posted by SpiritBob
MySql version: 5.6.26-log MySql Community Server (GPL)
by default i was using utf8, but to resolve the issue i needed to change everything to utf8mb4, but the problem still persists, so maybe I didn't do the transition correctly or the plugin does not support utf8mb4.
I tried many guides (like https://mathiasbynens.be/notes/mysql-utf8mb4), still no luck ( I couldn't do some steps fully and even skipped some, but when i write
SHOW VARIABLES WHERE Variable_name LIKE 'character\_set\_%' OR Variable_name LIKE 'collation%';
Everything appears to be utf8mb4/utf8mb4_unicode_ci except for character_set_system and character_set_filesystem, which inclines me to think that the problem is on the plugin's end.
EDIT: I followed this guide and did everything, yet still experience the same problem - https://my.bluehost.com/cgi/help/mysql-to-utf8
UPDATE: After reading the source file for the plugin, It was using utf8, so I changed it to use utf8mb4 and after compiling/deploying no errors appear!! It seems i finally fixed this shit.
Make sure that you also change the character sets and all those stuff for your mysql to fully remove any kind of problems (look into the 2 guides above). In the folder sqlscripts (Located in TF2 Web Ranking archive in main post), each .sql file is made to setup your tables with utf8. Make sure you change them to use utf8mb4 if planning on re-creating any of the tables. It will save you a lot of trouble.
|
I will have a look and see if there is a good solution for it.
Please dont forget, it does seems to be only a issue for mysql.
All other databases do not have this issue(mariadb, sqllite etc).
All other databases seems to be able to handle 4 byte characters as under UTF8.
Because of mysql has older utf8 character set that can only handle max 3 byte characters.
So mysql has added utf8mb4 character set and be able to support wider unicode characters.
but thats only from mysql version 5.5 or bigger.
I also know there is still huge amount of mysql server running 5.0 and 5.1 running and not supported by utf8mb4.
They mention those versions have still better performance then 5.5 or bigger so the database hosters most of the time dont upgrade yet because of the load they have on the database.
__________________