Re: LOAD DATA INTO doesn't work correctly with utf8

Dušan Pavlica schrieb:
> Try to convert file to latin1, if it's possible, create database with
> latin1 charset, create table with required structure (you can set utf8
> charset to string fields ) and then load data.
I can not convert the file into latin1, because it is multilingual (i.e. European, Japanese, Korean etc.).

> What client do you use to check whether data are OK? I can recommend
> MySQL Query Browser where I don't have to care about setting charset
> and collation parameters.
>

I checked the file in MySQL Query Browser too, but even there I get it wrong, when I imported it with a latin session. I get it displayed right, when I import it with utf8, but then I have the message with duplicate keys and get only half of the data.

Regards,
H.

-- 
"Wouldn't the sentence 'I want to put a hyphen between the words Fish
and And and And and Chips in my Fish-And-Chips sign' have been clearer
if quotation marks had been placed before Fish, and between Fish and
and, and and and And, and And and and, and and and And, and And and
and, and and and Chips, as well as after Chips?"


-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com