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 http://dev.mysql.com/doc/mysql/en/alter-database.html MightyData <[EMAIL PROTECTED]> 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 data. Is there a better way or something I missed? > > ------------------------------------------------------------------------- > Kirk Bowman Phone: 972-390-8600 > MightyData, LLC http://www.mightydata.com > FileMaker 7 Certified Developer FileMaker Authorized Trainer > Check out our FileMaker 7 training classes! > ------------------------------------------------------------------------- > > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]