Page 1 of 1
Test Post - SQL Error Reported
Posted: Wed Apr 04, 2018 11:20 pm
by Fred
Testing testing 1 2 3
Re: Test Post - SQL Error Reported
Posted: Wed Apr 04, 2018 11:20 pm
by Fred
Hello world
Re: Test Post - SQL Error Reported
Posted: Thu Apr 05, 2018 12:21 am
by Andreas
test
Re: Test Post - SQL Error Reported
Posted: Thu Apr 05, 2018 12:21 am
by Andreas
That worked...weird
Re: Test Post - SQL Error Reported
Posted: Thu Apr 05, 2018 2:53 am
by ToxicGumbo
SHOW DATABASES;
\dt;
SELECT * FROM freeems;
Re: Test Post - SQL Error Reported
Posted: Thu Apr 05, 2018 8:11 pm
by Fred
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
Re: Test Post - SQL Error Reported
Posted: Thu Apr 05, 2018 8:24 pm
by Fred
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.