Lou Olsten wrote:
> 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/
