note 26946 deleted from function.base64-encode by didou
| From: | didou@php.net | Date: | Thu, 29 May 2003 20:56:23 +0000 |
| Subject: | note 26946 deleted from function.base64-encode by didou | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-49306@lists.php.net to get a copy of this message | ||
Note Submitter: webmaster@mainbotics.com
----
In response to guy at bhaktiandvedanta dot com:
You can simply save the images in a blob field (Binary Large OBject) in the data base just by using
mysql_escape_string(), which escapes NULL, CR, LF, \x1A, ... and other special-meaning characters,
so you can directly insert the image into the sql query without any problem and without any kind of
encoding (just the slashes). That way, you'll save space at the data base and when you get the
image, you can directly dump it to the browser without making any kind of decoding. The script will
so become faster and more efficient, and MySQL is already aware about the field contains binary
data, not text data, to threat it in a convenient way.