Today my database character set and collation is set to latin1. All of the tables in the database are however already set to DEFAULT CHARSET=utf8 and all data is utf8.
Is if it is safe to change character set and collation of the database to utf8?
Is it safe to also set the default settings in the my.cnf file with:
[mysqld] default-character-set = utf8
A typical table in the database looks like this:
CREATE TABLE `tblpayment` ( `paymentid` int(11) NOT NULL AUTO_INCREMENT, `userid` mediumint(9) DEFAULT NULL, `payed` enum('False','True') CHARACTER SET latin1 DEFAULT 'False', PRIMARY KEY (`paymentid`) ) ENGINE=InnoDB AUTO_INCREMENT=72803 DEFAULT CHARSET=utf8;
As you can see the enum "payed" is still using latin1 for some reason, however the rest of the table is utf8. Is it safe to change the CHARACTER SET of the enum to utf8 instead?