Hello.
Looks like you've solved the problem? Remove quotes from show create... statements: show create table table_name; Steve Mansfield <[EMAIL PROTECTED]> wrote: > ------------------- > On Saturday 27 November 2004 12:38, Steve Mansfield wrote: > > Seem to be answering my own questions here...:-) > > Looks like it's a MySQLcc problem. > > Dumped tables from the live server and then, rather than running them as a > sql > query via MySQLcc, I did it from the command line with: > > mysql -h host -D database -p < filename.sql > > And that worked. The data stayed as latin1. For some reason, MySQLcc is > messing with the data and turning it into utf-8. Go figure... > -- 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]