ansaurus

Question

Answer 1

A:

What is the collation of each table? Sounds to me like the 2nd table is still encoded ISO-8859-1 or similar.

Plus, what tool are you using to look at the destination data? Are you sure the connection that tool uses is UTF-8 as well?

Pekka 2009-12-18 12:04:43

Here is the SHOW CREATE TABLE code:CREATE TABLE `Country` ( `id` int(10) unsigned NOT NULL auto_increment, `country` varchar(255) NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8how do i get the collation ?

Dario 2009-12-18 12:06:37

i use --default-character-set=utf8 to import data using mysql < file

Dario 2009-12-18 12:19:12

Try DESCRIBE. -

Pekka 2009-12-18 12:28:03

to look at destination data i use mysql client, and yes, i'm sure it is a utf8 connection:| character_set_client | utf8 || character_set_connection | utf8 |

Dario 2009-12-18 12:31:44

Character sets and table/column collations are not the same. What collation are your tables/columns? What does DESCRIBE say? Check http://dev.mysql.com/doc/refman/5.0/en/charset.html

Pekka 2009-12-18 16:07:34

Answer 2

A:

try

iconv --from-code=ISO-8859-1 --to-code=UTF-8 ./file >file.utf8
mysql --default-charset=utf8 < file.utf8

If it does not work i advise you to import data then convert it

ALTER TABLE tbl_name CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

hope it'll help

Darkyo 2010-03-07 13:29:53

ansaurus

tags:

views:

answers:

MySQL UTF8 Database migration

related questions