Incorrect string value: 'xC4x81ne' for column 1

Incorrect string value: ‘\xC4\x81ne’ for column

ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

Here is what the above code is Doing:
1. ALTER TABLE: This tells MySQL that we want to change the table named table_name.
2. CONVERT TO CHARACTER SET utf8mb4: This is the part that does the conversion.
3. COLLATE utf8mb4_unicode_ci: This sets the collation of the converted data to utf8mb4_unicode_ci.

Similar Posts