On Wednesday 07 Jan 2004 21:06, Ian O'Rourke wrote:
(B> ---- Original Message -----
(B> From: "Steve Folly" <[EMAIL PROTECTED]>
(B>
(B> > At work we are currently investigating ways of filing all our
(B> > electronic documents.
(B>
(B> I don't know the answer, but it's an interesting question. We are currently
(B> looking at using more and more SQL (we use MySQL now in places), and we
(B> face looking the issue of storing PDF files and such in a back-end. We also
(B> have Lotus Domino - which is very good at this sort of thing - but I'd
(B> still be interested in the discussion.
(B
(BI am setting up a similar arrangement for my business but in my case the
(Bstored documents will only need to be accessed in case of a dispute about
(Bmeasurements. This happens rarely only several times a year, worst case less
(Bthan once a month so I just dump the blob field to a file and look at it
(Bthat way.
(B
(BCREATE TABLE charts (no int not null primary key, comments varchar(255), chart
(Bmediumblob);
(B
(BSELECT chart INTO DUMPFILE '/home/richard/image.jpg' FROM charts WHERE no=1;
(B
(BI find at present from reasons I can't work out if the image to be stored is a
(Bjpg then there is no problem but if it is a tiff them MySQL won't store it.
(B
(Binsert into charts values(5,'No
(Bcomment',(LOAD_FILE("/home/richard/fred.jpg")));
(B
(Bworks fine.
(B
(Binsert into charts values(5,'No
(Bcomment',(LOAD_FILE("/home/richard/fred.tiff")));
(B
(Binserts NULL instead of the image. fred.jpg and fred.tiff both exist in the
(Bsame directory.
(B
(B
(B
(B--
(BRegards
(B
(BRichard
(B
(B
(B--
(BMySQL General Mailing List
(BFor list archives: http://lists.mysql.com/mysql
(BTo unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
