DIYEFI.org Forum
http://forum.diyefi.org/

Test Post - SQL Error Reported
http://forum.diyefi.org/viewtopic.php?f=17&t=2851
Page 1 of 1

Author:  Fred [ Wed Apr 04, 2018 11:20 pm ]
Post subject:  Test Post - SQL Error Reported

Testing testing 1 2 3

Author:  Fred [ Wed Apr 04, 2018 11:20 pm ]
Post subject:  Re: Test Post - SQL Error Reported

Hello world

Author:  Andreas [ Thu Apr 05, 2018 12:21 am ]
Post subject:  Re: Test Post - SQL Error Reported

test

Author:  Andreas [ Thu Apr 05, 2018 12:21 am ]
Post subject:  Re: Test Post - SQL Error Reported

That worked...weird

Author:  ToxicGumbo [ Thu Apr 05, 2018 2:53 am ]
Post subject:  Re: Test Post - SQL Error Reported

SHOW DATABASES;
\dt;
SELECT * FROM freeems;

Author:  Fred [ Thu Apr 05, 2018 8:11 pm ]
Post subject:  Re: Test Post - SQL Error Reported

The answer lies here:

(11:19:19) andreas: SQL ERROR [ mysqli ] Incorrect string value: '\xF0\x9F\x98\xAC I...' for column 'post_text' at row 1 [1366]
<SNIP>
(11:24:03) andreas: I took out the smileys, and then it posted. <SNIP>

Found it:

U+1F62C \xF0\x9F\x98\xAC GRIMACING FACE

And got the same error! :-D So removed the actual character. Go to this page and search for the code to see the face responsible for this thread: https://apps.timwhitlock.info/emoji/tables/unicode

Author:  Fred [ Thu Apr 05, 2018 8:24 pm ]
Post subject:  Re: Test Post - SQL Error Reported

To fix this I'd need to update the MySQL instance to use the utf8_mb4 character set instead of plain utf8. I will look into doing that at some point, but not anytime soon.

Page 1 of 1 All times are UTC [ DST ]
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/