I was trying to paste this code https://pastebin.com/e3Dfs0Na
and the forum responded with an SQL error. Only upon removing the unicode character, I was able to post the code.
What is going on there?
Unicode Bug in the forum!
- NicTheQuick
- Addict
- Posts: 1227
- Joined: Sun Jun 22, 2003 7:43 pm
- Location: Germany, Saarbrücken
- Contact:
Re: Unicode Bug in the forum!
I guess the database is not able to store utf-8 characters with more than 2 bytes. To make it work the encoding on the database side has to be switched from utf8 to utf8mb4.
The english grammar is freeware, you can use it freely - But it's not Open Source, i.e. you can not change it or publish it in altered way.
- Joakim Christiansen
- Addict
- Posts: 2452
- Joined: Wed Dec 22, 2004 4:12 pm
- Location: Norway
- Contact:
Re: Unicode Bug in the forum!
https://www.eversql.com/mysql-utf8-vs-u ... d-utf8mb4/NicTheQuick wrote:I guess the database is not able to store utf-8 characters with more than 2 bytes. To make it work the encoding on the database side has to be switched from utf8 to utf8mb4.
"Well, it turns out we were wrong. We quickly realized that MySQL decided that UTF-8 can only hold 3 bytes per character. Why? no good reason that I can find documented anywhere. Few years later, when MySQL 5.5.3 was released, they introduced a new encoding called utf8mb4, which is actually the real 4-byte utf8 encoding that you know and love."
lol, they tried to implement a standard and did it wrong...
I like logic, hence I dislike humans but love computers.