Nick,
Tuesday, April 09, 2002, 5:21:00 PM, you wrote:
NS> Is there a way to store files in MySQL? Looking to store somthing like a
NS> zip file in the databaseand be able to retrieve/download it from something like
ASP.
Yes, you can store files in the BLOB fields. You can find some info
about BLOB column types and storage requirements in the MySQL manual:
http://www.mysql.com/doc/B/L/BLOB.html
http://www.mysql.com/doc/n/o/node_368.html
To put binary data in the database you can use LOAD_FILE() function.
LOAD_FILE() function is described at:
http://www.mysql.com/doc/S/t/String_functions.html
If you don't use LOAD_FILE() - don't forget to escape chars. You
can find the list of chars to escape and escape sequences at:
http://www.mysql.com/doc/S/t/String_syntax.html
To read binary data use the SELECT statement.
NS> Thanks
NS> -Nick
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
