hi all
i'm having the following issue, that i'm not sure how to resolve
i have a comma seprated file, which imports fine with;
LOAD DATA LOCAL INFILE 'path/top/file.txt' REPLACE INTO TABLE `tablename` FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\r';
but lines with latin1 characters do not import correctly eg.
"5","België"
'5', 'Belgi'
or
"53","Bartók","Béla","","1881","1945","","","","","","","","","Bartók, Béla"
'53','Bartók','Béla','','1881','1945','','','','','','','','','Bartk, Bla'
i'm using a installation on os x, 4.0.18
Can someone please give some advise on how to proceed? (ps, i can use these characters with clients like (phpmyadmin or CocaoMySQL)
thanks
bas
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]