From: Date: October 28 2006 8:21am
Subject: utf8 importing problem
List-Archive: http://lists.mysql.com/mysql/202985
Message-Id: <4543131E.9622.A4882DA@python.hope.cz>
MIME-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7BIT

I use MySQL database with utf8 character set and utf8_czech_ci 
collation. 
It works well on Linux server but when I try to 
export the data and import into the same database but running on XP machine the utf8 is 
gone.Instead of a proper coding there are some strange characters.

I used 
mysqldump --default-character-set=utf8 mimi >/home/Result.sql 
to export data to /home/Result.sql file on Linux machine. 
Then I downloaded the file to my XP and here I used 
mysql --default-character-set=utf8 mimi < Result.sql 
to import data. 
Is it correct? 

Any help would be appreciated

L.

------- End of forwarded message -------