Hello.
Strange behavior. You said that both servers configured to use latin1? What output produced show variables like '%char%'; show variables like '%colla%'; show create database 'database_name'; show create table 'table_name'; on both servers? Also send your my.cnf files. Steve Mansfield <[EMAIL PROTECTED]> wrote: > ------------------- > On Saturday 27 November 2004 12:16, Steve Mansfield wrote: > | ------------------- > | > | On Friday 26 November 2004 17:58, Gleb Paharenko wrote: > | | Hello. > | | > | | What charset produced mysqldump with --default-character-set=latin1 > | | command line option? > | > | Hmm, that still produced a file with utf-8 characters, which means they > | must be stored that way in the table, no? (Although MySQLcc sees them > | correctly). > | > | (BTW, I've configured Kwrite, the editor I'm using, to open/save as > | iso-8859-1). > > Just to provide a bit more info - and to double-check - I exported the table > from the live system (via phpMyAdmin) and looked at it on my local system and > it was in latin1. I dropped the table from the live system, then uploaded the > copy of the table that I'd dumped from my local system using the > --default-character-set=latin1 option. On the live system, this now has utf-8 > characters (so it's nothing to do with my editor...). > -- 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]