Incorrect string value: '\\xF0\\x9F\\x91\\x8F\\xF0\\x9F...'
Posted by: Michael Rubin
Date: January 14, 2019 02:26PM

After updating from MySQL Connector/J 5.1.47 to 8.0.13, my service is sporadically getting into a state where any attempts of inserting Unicode values gives errors along the lines of:

Incorrect string value: '\\xF0\\x9F\\x91\\x8F\\xF0\\x9F...'

My database, table and columns are all set to utf8mb4. Historically I have not included any character encoding options in the URL, but I have tried including characterEncoding=UTF-8 and it did not help. My server is currently running with the following settings:

character_set_client: utf8mb4
character_set_database: utf8mb4
character_set_results: utf8mb4
character_set_connection: utf8mb4
collation_connection: utf8mb4_bin
collation_server: utf8mb4_bin
character_set_server: utf8mb4

I never had any issues on Connector/J 5.1.47. The trouble started after upgrading to 8.0.13. Is this a known problem? How can I further debug it?

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.