Incorrect string value
I am trying to store fields from an RSS feed. The feed is UTF-8. The database is returning "Incorrect string value" when inserting a row with a Unicode Smiling Face with Smiling Eyes (Unicode U+1F60A stored as 4 byte UTF-8). The CHARACTER SET is utf8mb4 and COLLATION utf8mb4_unicode_ci. I don't understand why this doesn't work. I might be willing to re-code the string with invalid characters as the Unicode REPLACEMENT character but I don't know the covered range for this character set and collation.
Answer Answered by Jeffrey Taylor in this comment.
Changing the console client charset (both mariadb client and application) and converting all the string fields to utf8mb4 worked. At the time I asked the question, it didn't appear to. I must have not restarted something.
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
