Re: How to change table character set

2005-09-27 Thread Gleb Paharenko
Hello. Have a look here: http://dev.mysql.com/doc/mysql/en/charset-upgrading.html http://dev.mysql.com/doc/mysql/en/charset-conversion.html MightyData wrote: > I have a database that was created with MySQL 4.0. The character set for > each table is latin1. I have upgraded the server

How to change table character set

2005-09-24 Thread MightyData
I have a database that was created with MySQL 4.0. The character set for each table is latin1. I have upgraded the server to MySQL 4.1. I would like to change the character set for each table to utf8. What is the correct procedure? Can I just change the table character set with an alter statement o