pardon me for asking a stupid question, but when your storing data into MySQL or any database for that matter, isn't "data" data? Does this have something to do with the BLOB type? ( Which I've never understood anyway ). I'm very new at this and am wanting to store documents that have database fields in them so I am following this discussion closely trying to learn something.
Troy "Richard Davies" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Thursday 08 Jan 2004 12:33, Harald Fuchs wrote: > > In article <[EMAIL PROTECTED]>, > > > Richard Davies <[EMAIL PROTECTED]> writes: > > > I find at present from reasons I can't work out if the image to be stored > > > is a jpg then there is no problem but if it is a tiff them MySQL won't > > > store it. > > > > insert into charts values(5,'No > > > comment',(LOAD_FILE("/home/richard/fred.jpg"))); > > > > works fine. > > > > insert into charts values(5,'No > > > comment',(LOAD_FILE("/home/richard/fred.tiff"))); > > > > inserts NULL instead of the image. fred.jpg and fred.tiff both exist in > > > the same directory. > > > Maybe fred.tiff is larger than max_allowed_packet? > > No it isn't. fred.tiff is just fred.jpg copied and renamed. Apart from the > name the files are identical at about 400k and the max_allowed_packet is set > in /etc/my.cnf to be 10Meg. > > It is extemely odd but this install of MySQL doesn't seem to like the > extension tiff. > > -- > Regards > > Richard > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 1/2/04 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
