> Can I use MySQL to store pictures as part of a record?
You CAN.
> Should I just try to store the name of the picture?
Yes. If you have FTP Access or similiar, I would prefere this!
Some remarks from the manual :
-- Insert a File located locally on MySQL-Serverinto a blob-column
INSERT INTO media_binaerdaten (Daten) values(load_file("c:/tmp/test.zip");
-- get length of blob-fields
SELECT Key,length(Daten) FROM `media_binaerdaten` WHERE 1
SELECT Daten FROM `media_binaerdaten` WHERE FKMedia_ID=47 INTO OUTFILE
"C:/tmp/test.zip"
-> get data WITH escapes, can be insertet again
SELECT Daten FROM `media_binaerdaten` WHERE FKMedia_ID=47 INTO DUMPFILE
"C:/tmp/test.zip"
-> get raw data (WITHout) escapes, can be used as "binary", e.g. *.zip or
*.exe
Escaping
---------------------------------------------------------------
If you want to insert binary data into a BLOB column, the following
characters must be represented by escape sequences:
NUL ASCII 0. You should represent this by `\0' (a backslash and an
ASCII `0' character).
\ ASCII 92, backslash. Represent this by `\\'.
' ASCII 39, single quote. Represent this by `\''.
" ASCII 34, double quote. Represent this by `\"'.
If you write C code, you can use the C API function mysql_escape_string
() to escape characters for the INSERT statement. See section 22.3 C
API function overview. In Perl, you can use the quote method of the DBI
package to convert special characters to the proper escape sequences.
See section 22.5.2 The DBI interface.
You should use an escape function on any string that might contain any
of the special characters listed above!
greetings by a "busted by blobs"-coder !
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
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
