Indiana jones and the search for the lost ranks

[Im 'corneum]

so you all know how some people do not get their ranks after finishing sometimes. as it appears noone has ever found a answer to how this comes up, especially stompie seems to have it very often.
first off: i have no answer either just some hints but i need your help to finish this.
i gave myself a name that teeworlds couldnt show, in this case a emoji -> ("🖕🏼"[yeah i know childish blabla])
when you finish a map with those symbols you cant rank yourself, just as it is with stopmie. if you teamfinish you also dont get the rank and the points. but where do they go. they go to a "player" named "????" https://ddnet.tw/players/-63--63--63--63-/ as you can see on that player profile i tried some stuff out already with schinese symbols as well.
now if you finished with the real name of "????" ingame first and then play as a emoji, then the get delivered to "????????"(8 question marks) but for some reason i cant reach this profile on the website to look after it.
to clarify this all more i have made some screens which i will just attach at the end because im too lazy to put them in the right places in the text, and also they are really self-explaining
yeah maybe deen knows more, maybe im totally stupid and everyonme already knows this. but whatever

[Chairn]

That doesn't explain why stompie who has only latin character doesn't get ranks.

[Im 'corneum]

That doesn't explain why stompie who has only latin character doesn't get ranks.

yeah as i said im not behind it. but i think i got a clue

[deen]

A few problems there:

1. We hava database servers and game servers. When the game server has no network connection to the database server, then it can't write the rank. In that case it should write the rank to a file instead that can be manually added later.
2. I have restored all ranks from files, but I didn't see any from stompie.
3. Our utf8 storage in the database is wrong. I wrongly assumed that "utf8" means utf8, but actually "utf8" only works for up to 3 byte characters. The real utf8 is called "utf8mb4". This has historical reasons in MySQL/MariaDB. I will try to fix it today.
4. If stompie or anyone else has a problem where a rank is not stored immediately, then please make a thread or write me a message immediately with the time, name, server location, port. Then I can check the logs (deleted after 24-48 hours) and verify the source of the problem.

[stompie]

recently i havent had this issue (mostly cause i havent finished as many maps as normal xD) but i got used to it when it happens but thanks for the explanation

[deen]

Database now uses utf8mb4. All characters should work now on restarted servers. /map and /mapinfo only work on servers that were restarted already as well.