Incorrect string value
I have a table in an InnoDB database.
The character set is utf8mb4 and the collation is utf8mb4_0900_ai_ci. I have a field in the table defined as longtext, whose collation is also utf8mb4_0900_ai_ci.
When I copy the following content:
Man they are on it this week😊
Into this field, I get the following warnings:
1300 - Invalid utf8mb3 character string: 'F09F98'
1366 - Incorrect string value: '\xF0\x9F\x98\x8A' for column 'Action' at row 1
What do I need to do to fix this?
Subject
Views
Written By
Posted
Incorrect string value
333
April 24, 2024 07:31AM
137
April 29, 2024 01:31PM
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.