
It is fixable. I’ve dealt with similar transformation issues in the past (with a rather different cause). You can’t use iconv to do the conversion of what the web server outputs, as there are a few bytes that show up that aren’t considered to be valid cp1252 code points. We’ll see if the bit of Perl I’ve attached makes it through; it works on the page content I paste in, even not mangling the actually UTF-8 post_title. It doesn’t include any of the DBD::MySQL bits that you would use to SELECT and UPDATE post_content FROM the wp_posts table (remember to take a full backup first).
On Dec 2, 2021, at 09:11, Stewart C. Russell via talk <talk@gtalug.org> wrote:
On 2021-12-01 21:53, Jamon Camisso via talk wrote:
Do any of the casting suggestions on that link that I sent fix it?
I haven't had a chance to try them yet, but your note about the transformation being reversible gives me hope that it can be fixed.
Seneca