Hello.
If you're upgrading from 4.0 read:
http://dev.mysql.com/doc/mysql/en/charset-conversion.html
If your tables were created in 4.1 you may use ALTER TABLE and ALTER
DATABASE to change the table (or database encoding). See:
http://dev.mysql.com/doc/mysql/en/alter-table.html
On Wednesday 24 August 2005 20:01, MightyData wrote:
> What is the proper procedure to change the table (or database encoding)
> from latin1 to UTF-8 with MySQL 4.1.x? My thought is to export the data to
> text file, drop the table, recreate the table with the proper encoding and
> then import the
What is the proper procedure to change the table (or database encoding) from
latin1 to UTF-8 with MySQL 4.1.x? My thought is to export the data to text
file, drop the table, recreate the table with the proper encoding and then
import the data. Is there a better way or something I missed?
-
