jdleung
06-05-2008, 08:46 AM
I think it's problem of database.
my site has been moved to a new server, the database tables are charset utf8, so I convert all comments to utf8 and save as sql file in utf8 format, import the file via phpmyadmin, select charset "utf8". Result: all the comments display in mess.
alter the table to charset latin1 and empty the table, import once again, select charset "latin1". Result: comments display in normal.
For future use, I would like to change all the tables to charset utf8, how can I do it?
thanks.
my site has been moved to a new server, the database tables are charset utf8, so I convert all comments to utf8 and save as sql file in utf8 format, import the file via phpmyadmin, select charset "utf8". Result: all the comments display in mess.
alter the table to charset latin1 and empty the table, import once again, select charset "latin1". Result: comments display in normal.
For future use, I would like to change all the tables to charset utf8, how can I do it?
thanks.