Urgent help: character encoding???

2002-10-11 Thread Nasir Aziz Gill
Hi fellows, Thanks for your help. Finally I have the data in the table. But I lost these special Characters( à ? å ä ); Which when I imported from the text file, they existed. But I can't find them now by Select statement. Should I use Character encoding if so, then how? I am using Java wit

Urgent Help! Importing Data from Text File...

2002-10-10 Thread Nasir Aziz Gill
Hi fellows, I got one text file of 9816 records (9816 lines) seprated by commas and enclosed by the inverted quotes and seprated by the end of lines. But when I import the file, it only gets half of records in the table using below mentioned command; LOAD DATA INFILE 'user.txt' INTO TABLE userda