comments in mess

[jdleung]

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.