import problem

[tvrtko]

I tried to import data containing some central-european characters from file to db.
File is tab delimited and looks somehow like this:

10 u?enje a b

After issuing mysqlimport command I got just "u" instead of "u?enje" in second field.
Same thing happens when I use import statement from Command Line Client. It's obviously because of letter "?".

Does anybody know how to solve this problem?
Thank's in advance.

 

[hvass]

My guess is that mysqlimport treats ? as a parameter you can pass to the program. Why use mysqlimport ? what about sql code

drop table if exists test;
create table test
(
field1 char(50),
field2 char(50),
field3 char(50),
field4 char(50)
);

load data infile 'C:\\dev_code\\tektips\\testdata.txt'
into table test
fields terminated by '\t'
lines terminated by '\r\n';

select * from test;