Question #6951   Submitted by Answiki on 10/16/2022 at 08:06:12 PM UTC

How to solve the MySQL error "#1366 - Incorrect string value" ?

Answer   Submitted by Answiki on 10/16/2022 at 08:07:33 PM UTC

SQL error #1366 - Incorrect string value is usually related to an encoding problem of characters in utf8.


The most common solution is to convert tables to utf8mb4_unicode_ci.


Be careful, however, to convert tables and columns that may have a different format than the table.

2 events in history
Answer by Answiki on 10/16/2022 at 08:07:33 PM

SQL error #1366 - Incorrect string value is usually related to an encoding problem of characters in utf8.


The most common solution is to convert tables to utf8mb4_unicode_ci.


Be careful, however, to convert tables and columns that may have a different format than the table.

Question by Answiki 10/16/2022 at 08:06:12 PM
How to solve the MySQL error "#1366 - Incorrect string value" ?
# ID Query URL Count

Icons proudly provided by Friconix.