Re: Saving pictures in MySql

2001-02-23 Thread Peter Skipworth
Agreed I generally set aside a directory for any images, etc, per table, and simply save any images as [primary_key].jpg. That way you can write simple GetImage([table_name], [primary_key]) functions to return the location/URL of the matching image. regards, P On Fri, 23 Feb 2001, Mikel Ki

RE: Saving pictures in MySql

2001-02-23 Thread Barry Radloff
I hearterly concur ... -Original Message- From: Mikel King [mailto:[EMAIL PROTECTED]] Sent: 23 February 2001 03:46 To: Barry Radloff Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: Re: Saving pictures in MySql Greetings, In most cases you will find that the storage o

Re: Saving pictures in MySql

2001-02-23 Thread Mikel King
Greetings, In most cases you will find that the storage of pictures and mp3's for instance are better left to the host fs rather than the dbs. Then you would only store the link to such files. Some will argue that this slows down access to the perticular file et cettera, blah blah blah...but

RE: Saving pictures in MySql

2001-02-23 Thread Barry Radloff
A blob is a nice field to use I guess see these attachements from when I asked the same Q... Some of them may or maynot be helpful.. regards Barry -Original Message- From: Danie Weideman [mailto:[EMAIL PROTECTED]] Sent: 23 February 2001 02:02 To: [EMAIL PROTECTED] Subject: Saving pictu