Re: uploading and downloading files to MySQL (--2--)

2003-01-09 Thread Mariusz
What type of field should I use for storing the path; just VARCHAR I guess? And as far as the filenames - make up some random file name for each submitted file? thanks, Mariusz ps. If storing files in the DB is not common, what exactly is the BLOB type for? - Original Message - From: "R

Re: uploading and downloading files to MySQL (--2--)

2003-01-09 Thread R. Joseph Newton
Hi Mariusz, I'd say VARCHAR(255), although even that leads to a sticky issue with DBs, since paths can be of any length up to the system maximum, [which may or may not exist]. It is true that the BLOB type exists in most databases, as a convenience. There may be some cases where the DB would b

RE: uploading and downloading files to MySQL (--2--)

2003-01-09 Thread Westgate, Jared
Mariusz wrote: > What type of field should I use for storing the path; just > VARCHAR I guess? > And as far as the filenames - make up some random file name for each > submitted file? This is a little off topic for a Perl list, but I'll give it a shot. Be forewarned, that I do not know much a