On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote:
(B> In article <[EMAIL PROTECTED]>,
(B
(B> Richard Davies <[EMAIL PROTECTED]> writes:
(B> > I find at present from reasons I can't work out if the image to be stored
(B> > is a jpg then there is no problem but if it is a tiff them MySQL won't
(B> > store it.
(B
(B> > insert into charts values(5,'No
(B> > comment',(LOAD_FILE("/home/richard/fred.jpg")));
(B
(B> > works fine.
(B
(B> > insert into charts values(5,'No
(B> > comment',(LOAD_FILE("/home/richard/fred.tiff")));
(B
(B> > inserts NULL instead of the image. fred.jpg and fred.tiff both exist in
(B> > the same directory.
(B
(B> Maybe fred.tiff is larger than max_allowed_packet?
(B
(BNo it isn't. fred.tiff is just fred.jpg copied and renamed. Apart from the
(Bname the files are identical at about 400k and the max_allowed_packet is set
(Bin /etc/my.cnf to be 10Meg.
(B
(BIt is extemely odd but this install of MySQL doesn't seem to like the
(Bextension tiff.
(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]
