Re: Load data infile fails to put entire PDF into one record

2005-11-10 Thread Whil Hentzen
Gleb Paharenko wrote: Hello. Are you sure that you want to load PDF with LOAD DATA INFILE? Well, I had been sure, but not so much anymore. s Maybe LOAD_FILE is that you want: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html Yup, this was the ticket. I'd seen several

Re: Load data infile fails to put entire PDF into one record

2005-11-09 Thread Gleb Paharenko
Hello. Are you sure that you want to load PDF with LOAD DATA INFILE? Maybe LOAD_FILE is that you want: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html Whil Hentzen wrote: Hi folks, I want to load a set of PDFs into a MySQL 5 ISAM table. I'm using the following

Load data infile fails to put entire PDF into one record

2005-11-08 Thread Whil Hentzen
Hi folks, I want to load a set of PDFs into a MySQL 5 ISAM table. I'm using the following command LOAD DATA INFILE '1037021.pdf' INTO TABLE complete FIELDS TERMINATED BY '%%EOF' (d_c) in the Query Browser 1.1.17, MySQL 5.0.15, running on W2K. Field d_c is defined as LONGTEXT. The