Re: Does MySQL support the Karen language

[Peter Brawley]

> We tried changing one of our database tables as such
> "ALTER TABLE OurTextLang CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;"

What was it before? Often you have to change the charset to VarBinary, then to utf8mb4.

> tried to copy the text from Excel to phpMyAdmin edit mode after the ALTER table above, the Karen symbols didn't preserve.

The Excel data was saved in what charset? It may need to be massaged.

Client charset settings are also important. What is phpMyAdmin set up to use?

For a useful summary of how to handle char mismatch problems in MySQL see http://mysql.rjweb.org/doc.php/charcoll