How do I change the charactset on mysql 5.x from utf8 to latin1.
Thanx for the help
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.