Most likely the UTF8 is still in the data base, but whatever program you are using to view it is not displaying UTF8 properly. MySQL's command line program will not, for example, even if you SET NAMES "utf8".
Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: Saturday, October 28, 2006 2:22 AM > To: mysql@lists.mysql.com > Subject: utf8 importing problem > > 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 ------- > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
