importing nonprintable delimiters with mysql ?

Hi I was wondering if someone could reply with a command from the
mysql client that I can issue which will import a flat file have 2
columns and a 034 octal (decimal 28, hex 1C) as the delimiting value.
I have not been able to find a mysqlimport command that will work.. I
tried this but no luck:

mysqlimport instinct --fields-terminated-by= '1C' --fields-enclosed-
by='\n' 'e:\TISS1b.txt';

Thanks,

Jack

Re: importing nonprintable delimiters with mysql ?

Jack wrote:
> Hi I was wondering if someone could reply with a command from the
> mysql client that I can issue which will import a flat file have 2
> columns and a 034 octal (decimal 28, hex 1C) as the delimiting value.
> I have not been able to find a mysqlimport command that will work.. I
> tried this but no luck:
>
> mysqlimport instinct --fields-terminated-by= '1C' --fields-enclosed-
> by='\n' 'e:\TISS1b.txt';
>
> Thanks,
>
> Jack
>
Try doing it directly from the mysql prompt with 'load data infile':

http://dev.mysql.com/doc/refman/4.1/en/load-data.html