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