Announcement

Announcement Module
Collapse
No announcement yet.

MySQL 5.x characterset change

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • MySQL 5.x characterset change

    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.

    Comment

    Working...
    X