It is currently Thu Oct 17, 2019 9:26 pm

All times are UTC + 1 hour




Post new topic Reply to topic  [ 3 posts ] 
Author Message
 Post subject: Unicode Bug in the forum!
PostPosted: Wed Aug 21, 2019 10:52 am 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Sat Jul 23, 2011 1:13 am
Posts: 217
Location: Germany
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?


Top
 Profile  
Reply with quote  
 Post subject: Re: Unicode Bug in the forum!
PostPosted: Wed Aug 21, 2019 11:30 am 
Offline
Enthusiast
Enthusiast
User avatar

Joined: Sun Jun 22, 2003 7:43 pm
Posts: 446
Location: Germany, Saarbrücken
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.

_________________
Electronics, Crazy & Interesting Stuff, all that with text, image and sound? Click here!

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.


Top
 Profile  
Reply with quote  
 Post subject: Re: Unicode Bug in the forum!
PostPosted: Sun Aug 25, 2019 10:18 pm 
Offline
Addict
Addict
User avatar

Joined: Wed Dec 22, 2004 4:12 pm
Posts: 2447
Location: Norway
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.


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 3 posts ] 

All times are UTC + 1 hour


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  

 


Powered by phpBB © 2008 phpBB Group
subSilver+ theme by Canver Software, sponsor Sanal Modifiye