Re: behaviour of latin1 in mysql

[Peter Brawley]

> all default server settings/ charset as latin1, but the tables created have charset as utf8

> for the same table, I have data in both utf8 and latin1

Recipes for disaster.

You need character_set_client, character_set_server, database charset, table and column charsets to agree.

And when you inspect your recent data, it's extremely likely you'll find charset mixups, consider following the suggestionss at http://mysql.rjweb.org/doc.php/charcoll#fixes_for_various_cases