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

Reply via email to