- The original format of the data is unknown
- The new table is in
If I do
CONVERT(BINARY CONVERT(column USING latin1) USING UTF8) as mentioned here – it fixes all text, but converts something like:
© in the original column to
? in the new column.
If it helps to determine what original encoding it was in, the original text renders as e.g.
KotaÄiÄ‡i and converts to
Is there a way to both preserve special characters and restore correct utf8 text format?