View unanswered posts | View active topics It is currently Tue Dec 11, 2018 2:08 pm



Reply to topic  [ 7 posts ] 
Test Post - SQL Error Reported 
Author Message
Moderator
User avatar

Joined: Tue Jan 15, 2008 2:31 pm
Posts: 15200
Location: Home sweet home!
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!


Wed Apr 04, 2018 11:20 pm
Profile WWW
Moderator
User avatar

Joined: Tue Jan 15, 2008 2:31 pm
Posts: 15200
Location: Home sweet home!
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!


Wed Apr 04, 2018 11:20 pm
Profile WWW
LQFP112 - Up with the play

Joined: Mon Sep 09, 2013 11:11 pm
Posts: 102
test


Thu Apr 05, 2018 12:21 am
Profile
LQFP112 - Up with the play

Joined: Mon Sep 09, 2013 11:11 pm
Posts: 102
That worked...weird


Thu Apr 05, 2018 12:21 am
Profile
LQFP144 - On Top Of The Game
User avatar

Joined: Tue Jan 03, 2012 8:37 pm
Posts: 449
Location: Manhattan, KS. USA
SHOW DATABASES;
\dt;
SELECT * FROM freeems;

_________________
FreeEMS vehicle #23: 2003 Toyota "Toxic" Tacoma
Build page: http://forum.diyefi.org/viewtopic.php?f=3&t=1635)


Thu Apr 05, 2018 2:53 am
Profile
Moderator
User avatar

Joined: Tue Jan 15, 2008 2:31 pm
Posts: 15200
Location: Home sweet home!
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

_________________
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!


Thu Apr 05, 2018 8:11 pm
Profile WWW
Moderator
User avatar

Joined: Tue Jan 15, 2008 2:31 pm
Posts: 15200
Location: Home sweet home!
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!


Thu Apr 05, 2018 8:24 pm
Profile WWW
Display posts from previous:  Sort by  
Reply to topic   [ 7 posts ] 

Who is online

Users browsing this forum: No registered users and 2 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
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group
Designed by ST Software for PTF. ColorizeIt.