Re: Database Error: Incorrect string value

[szinski]

First suggestion is to set global_character_set...

I just upgraded from v2.0 to v2.1 and am seeing the same errors.

Incorrect string value: '\xF0\x9F\x98\x8E' for column 'body' at row 1
File: /home/pizza/public_html/forum/Sources/Subs-Post.php
Line: 1964

I can reproduce the error by using an emoticon in a message.

Where do I find the global_character_set setting? I checked my index.english.php file and it's set to UTF-8.
($txt['lang_character_set'] = 'UTF-8')

Also, I checked my database and collation is set to utf8mb3_general_ci for all tables.


Split from a year old topic ~ Steve

[szinski]

Never mind, figured it out, added global_character_set UTF-8 to my settings table and it's working now.