Changing the Character Set and Collate of your MySQL Database

Before changing the Char Set of your Database, here’s how to view the character set and collate of your database:

use YOUR_DATABASE_NAME;

show variables like “character_set_database”;

show variables like “collation_database”;

Now that you know your Database isnt UTF-8, you can try changing the character set from Latin to UTF 8:

alter database YOUR_DATABASE_NAME charset=utf8 collate=utf8_bin;