Hi,
I am trying to store fax images in mysql (they are about 1K per page), which
comes in as binary data. I am able to use mysql_escape_string(data, fax,
sizeof(fax)) to get the data into mysql, as well as only escaping ' and \
for the query string. I have tried both longblob and longtext mysql fields
for the fax data.
When I try to query the data back to a file from the command line (I use
Linux)
mysql -s -e "select fax_data from fax_table where record_number = '1'"
fax_db > fax1.01.fax
the data I get is all escaped (like \0) and when I try to send the fax out,
it has problems with the escaped characters (which were originally nulls,
and other non-printing characters). The file size is also much larger with
the output file than the input file.
Does anyone have any suggestions as to how I should get around this? I need
to be able to either store the fax as is or encode the fax in some simple
way and de-encode it on retrieval.
thanks
Joe Johnson
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
