MySQL 5.x characterset change

MySQL & MariaDB Other MySQL® Questions
1

Hi all
How do I change the charactset on mysql 5.x from utf8 to latin1.
Thanx for the help
Andrew

2

I thought MySQL 5.0 still has latin1 as default unless you specify
character-set=utf8 in my.cnf

In any case to go to latin1 you probably need to change back server default and then convert all your tables back to latin1, this is done using something like

ALTER TABLE ttt CONVERT TO CHARACTER SET latin1;

I might not remember exact syntax corectly but it is not plain ALTER TABLE CHATSET latin1 as this would only adjust default character set for columns in the table.

Just a warning - converting from utf8 to latin1 will cause data corruption if you have any non-latin1 stored in the database already.