I've been preparing some notes for my students on how to do this (using PHP/MySQL), if you're
interested have a look at http://www.scit.wlv.ac.uk/~jphb/sst/php/extra/images1.html - I've
only just put these notes together so if you can see any errors please let me know before I
mislead next year's students ;-)
You'd want to use a BLOB (binary large object) if that's what your goal is.
But if you're using this for a web application I'd highly suggest that you instead save images to a directory and make a reference to the path in the database. If you have many BLOB inserts or selects on a site, your database will be A LOT slower than pulling a string URL and then the browser simply retrieving the image from the directory specified.
-M
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 09, 2003 4:22 PM
To: [EMAIL PROTECTED]
Subject: <NEWBIE> how can i store images in a database?
hello,
i'm just changing from openbase SQL to MySQL, so i'm new here.
in openbase i had images stored in a database. the 'type' was set to 'object'.
i can't find something like that here and also not in the manual.
what should i use?
thanx for advance
cheers
christian
--
From Peter Burden, [EMAIL PROTECTED]http://www.scit.wlv.ac.uk/~jphb
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]