Programmer DD

Nov 23, 2021 · Databases

Why MySQL INSERT Fails with Incorrect String Value and How to Fix It

A colleague encountered an "Incorrect string value" error when inserting UTF‑8 text into a GBK‑encoded MySQL table, and the article explains how charset mismatches and the use of the CHAR() function cause the failure, then provides reproducible tests and concrete solutions.