Problem in using LOAD DATA LOCAL INFILE

[Neeraj]

Hi all

 

I have a table with following structure

 

CREATE TABLE   `dsc` (

  `ch_code` varchar(255) default NULL,

  `name` varchar(255) default NULL,

  `inof` blob

) ENGINE=InnoDB DEFAULT CHARSET=latin1;

 

And I have give a text file with following format 

 

Ü 

¢

Ch.Code  :02Ü 

MEATÜ        

 

         1   COUNTRY    : JORDAN


         2   COUNTRY    : SAUDI ARABIA   

             

                                                         

Ü 

¢

Ch.Code  :03Ü 

FISHÜ             

 

         1   COUNTRY    : JORDAN


                                                         

Ü 

¢

Ch.Code  :04Ü 

FISHÜ             

 

         1   COUNTRY    : JORDAN


         2   COUNTRY    : SAUDI ARABIA   

 

...

             

I am trying to import the text file into table. I have tried various ways
but unable to find the solution. the code I am trying to import the file is
as follows 

 

LOAD DATA LOCAL INFILE 'd:\\data3.txt'  INTO TABLE dsc FIELDS TERMINATED BY
'Ü\n' LINES TERMINATED BY '¢\n' (ch_code, name, info);

 

Can any one help me in loading this file…

 

Regards

 

Neeraj Black Bits