Hello, I'm trying to convert tables from Paradox DBs to MySQL and I have a big problem with setting correct character set. I created small application which generates csv files which are in cp1250 (I can't change it, it's charset ofmy Paradox DBs). My databases and tables in MySQL are in latin2. I tried in MySQL client command SET NAMES cp1250 and then LOAD DATA INFILE but that didn't help. Some chars were screwed up. If I create SQL script from part of csv file and load it by command SOURCE 'script.sql' then everything is OK. So, does anybody know the way how to import files from CSV directly by LOAD DATA INFILE without difficult manual conversions to sql scripts?
Thanks in advance for any help or ideas. Dusan Pavlica
