Re: Binary Data storage and Retrieval Problem

2001-07-11 Thread Jeremy Zawodny
On Thu, Jul 12, 2001 at 01:51:29AM +0200, Werner Stuerenburg wrote: > > Im my understanding, you are storing images. AFAIK, images should > not be stored in the db but in the filesystem. There's nothing wrong with doing it, as long as you understand what you're doing. After all, images are (from

Re: Binary Data storage and Retrieval Problem

2001-07-11 Thread Werner Stuerenburg
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

Binary Data storage and Retrieval Problem

2001-07-11 Thread Joe Johnson
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