Unicode Bug in the forum!

For everything that's not in any way related to PureBasic. General chat etc...
User avatar
Derren
Enthusiast
Enthusiast
Posts: 313
Joined: Sat Jul 23, 2011 1:13 am
Location: Germany

Unicode Bug in the forum!

Post by Derren »

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?
User avatar
NicTheQuick
Addict
Addict
Posts: 1224
Joined: Sun Jun 22, 2003 7:43 pm
Location: Germany, Saarbrücken
Contact:

Re: Unicode Bug in the forum!

Post by NicTheQuick »

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.
User avatar
Joakim Christiansen
Addict
Addict
Posts: 2452
Joined: Wed Dec 22, 2004 4:12 pm
Location: Norway
Contact:

Re: Unicode Bug in the forum!

Post by Joakim Christiansen »

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.
https://www.eversql.com/mysql-utf8-vs-u ... d-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: :lol: :lol: :lol: :lol: :lol: :lol: :lol:
lol, they tried to implement a standard and did it wrong...
I like logic, hence I dislike humans but love computers.
Post Reply