I tried this and it DOES work with my PDFs. However, I didn't fully understand how LOAD_FILE would handle all different kinds of binary data, so I tried the same thing with a JPG. It ended up dropping over half of the data. So although LOAD_FILE does work for my PDFs, how can I go about getting any form of data into a BLOB? I suspect it has something to do with converting the data to hex, but can't find a MySQL function to do that (that is, to take a file and convert it... not just a string of characters).
LOAD_FILE() should be able to handle any kind of data. To verify - md5sum /path/to/fname, and compare that with select md5(content) where ...
If that fails, file a bug report to MySQL developers after doing the regular nose pinching routine to make sure you are seeing things as they really are.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
