Im my understanding, you are storing images. AFAIK, images should
not be stored in the db but in the filesystem. You store only the
filename and other data (time etc.) in the db. There are some
remarks on this at php.net and other places, as this question is
posed often.
Sie schrieben am Mittwoch, 11. Juli 2001, 23:45:03:
> 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
--
Herzlich
Werner Stuerenburg
_________________________________________________
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax 0(049) 5224-997 409
http://pferdezeitung.de
---------------------------------------------------------------------
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
