Re: [SLUG] MySQL Document Storing

["[-SwM-]" <swm@nospam.zip.com.au>]

Daron,

Just load the entire contents of the file into a field of the table. I
would not, however recommend this if you plan to have a large number of
rows in the database. A better solution is to store the file path in the
database and use perl to read this address and catenate the file from the
filesystem itself.

Gavin Sherry
Editor - LinuxWorld.com.au

]}===++++---->
     __   _  
    / /  (_)__  __ ____  __
   / /__/ / _ \/ // /\ \/ /  . . .  t h e   c h o i c e   o f   a
  /____/_/_//_/_,_/ /_/_\         G N U   g e n e r a t i o n . . .


On Thu, 1 Jun 2000, Daron Barndon wrote:

> Sluggers,
> 	Using MySQL, (or similar SQL) is it possible to load a file (binary
> or text) into a BLOB field? If so, is there any documentation or examples
> available for this? I am in the process of building a web based document
> storage server using perl. Most of the documents will be MS Word etc... :-(
> 
> Thanks,
> 
> Regards,
> Daron Barndon                     Phn: +61293420864
> Senior Network Engineer       Fax: +61293420998
> Network Applications Center  Mob: +61402021061
> Cable & Wireless Optus        Pgr: 1300300669
> 
> --
> SLUG - Sydney Linux Users Group Mailing List - http://www.slug.org.au
> To unsubscribe send email to slug-request@nospam.slug.org.au with
> unsubscribe in the text
> 

--
SLUG - Sydney Linux Users Group Mailing List - http://www.slug.org.au
To unsubscribe send email to slug-request@nospam.slug.org.au with
unsubscribe in the text