🕸Fergus Duniho wrote on Fri, Jun 15, 2018 12:24 AM UTC:
I now have a plan for automating the rest of the conversions. In a test, I opened two PDO connections, one with charset set to utf8mb4 and one with it not. I read a column with it not set, and I updated the same column with it set. Doing this corrected it just as if I had cut and pasted the correct version. I don't want to stay on the computer much longer tonight, but I can write a script tomorrow that uses two different PDO connections to automatically convert the database strings to proper Unicode.
I now have a plan for automating the rest of the conversions. In a test, I opened two PDO connections, one with charset set to utf8mb4 and one with it not. I read a column with it not set, and I updated the same column with it set. Doing this corrected it just as if I had cut and pasted the correct version. I don't want to stay on the computer much longer tonight, but I can write a script tomorrow that uses two different PDO connections to automatically convert the database strings to proper Unicode.