MySQL Insert Can't Insert Special Characters
Is there any way to encode strings or perform a MySQL insert on a special character like ł or Ł. I can’t get it working, but it works just fine using another ETL process.
In my specific use case I’...
Forum Discussion
We’ve found a good workaround for this issue thanks to a recent MySQL Snap release that hasn’t even made it into the release notes yet.
The MySQL Bulk load snap allows you to define the working character encoding set, which successfully inserts UTF8 encoded strings into a table. So, it looks like Insert and Merge could use the same encoding flag change that Bulk Load supports, if possible.
Did you try to set properties for the mysql account with
useUnicode=yes
characterEncoding=utf8
It works for our Aurora instance.
THANK YOU jaybodra!!! Turns out our workaround broke in MySQL 5.7, and we stumbled upon our own question which now has your solution that worked. A bunch of employees with special characters in their names will be very grateful!
