Test Post - SQL Error Reported
Test Post - SQL Error Reported
Testing testing 1 2 3
DIYEFI.org - where Open Source means Open Source, and Free means Freedom
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!
Re: Test Post - SQL Error Reported
Hello world
DIYEFI.org - where Open Source means Open Source, and Free means Freedom
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!
Re: Test Post - SQL Error Reported
That worked...weird
- ToxicGumbo
- LQFP144 - On Top Of The Game
- Posts: 474
- Joined: Tue Jan 03, 2012 8:37 pm
- Location: Manhattan, KS. USA
Re: Test Post - SQL Error Reported
SHOW DATABASES;
\dt;
SELECT * FROM freeems;
\dt;
SELECT * FROM freeems;
FreeEMS vehicle #23: 2003 Toyota "Toxic" Tacoma
Build page: http://forum.diyefi.org/viewtopic.php?f=3&t=1635)
Build page: http://forum.diyefi.org/viewtopic.php?f=3&t=1635)
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
(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
DIYEFI.org - where Open Source means Open Source, and Free means Freedom
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!
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.
DIYEFI.org - where Open Source means Open Source, and Free means Freedom
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!
FreeEMS.org - the open source engine management system
FreeEMS dev diary and its comments thread and my turbo truck!
n00bs, do NOT PM or email tech questions! Use the forum!
The ever growing list of FreeEMS success stories!