Re: Incorrect string value: '\\xF0\\x9F\\x91\\x8F\\xF0\\x9F...'
Posted by: Filipe Silva
Date: January 15, 2019 05:56AM

Hi Michael,

Did you find the problem?

This works as expected. Are you sure the column you're adding data to is actually using UTF8MB4?

If you are not setting the character set explicitly on the column or table, then please check the actual database character set and not the default `character_set_database` value: "SELECT schema_name, default_character_set_name, default_collation_name FROM information_schema.SCHEMATA"

IHTH

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.