You can use a blob datatype, which can be used to store binary data. All you'd need is
for your script to print out the appropriate content-type for the image in question.
You could always create an app that let someone upload an image via a html form, and use a
CGI script to pull in the image and store it in the database.
You might want to think about how fast that would be, though, especially if you're storing
large images. I needed a solution like this once and ended up just using a varchar field
to store the path to the image
in the database, and just stored the image itself on the server. Easier on your database.
HTH,
Jason
Texscene_Support wrote:
> Can you store pictures in a mysql table. If so how?
>
> The next question (which may not be relevant to this mail group) is that I am trying
> to find a way of letting site visitors to send pictures to a mysql table on a remote
> server without FTP. Can this be done?
>
> Can we use a HTML form on a web page and perl-cgi code.
>
> Edd
--
--------------------------
Jason Nugent, BSc(hon)
Mal[MiC]Havoc
Certified Webmaster
MalHavoc@stripped
--------------------------
