Yes, normally convert from latin1 to binary, and from binary to utf8 (which
would also be the recipe to convert actual utf8 data which accidentally
ended up in latin1 columns to the proper definition without changing the
content). I would not know why that would take overly long for you.
An
Hi there,
I am looking for a way to convert about 40GB of InnoDB tables from latin1
character set to utf8. As true conversion will take ages, I had the idea of
just changing the character sets (and preferably collation, too) of the tables
without actually converting the data. Conversion could