On Thu, May 13, 2004 at 09:58:35PM -0400, ziada Mrisho wrote: > I got your e-mail address from a forum thread on SQL Help. I desperately need > help for my class project. I need to know how to insert an image in a > database table. When I issue a CREATE table command, what attribute > represents an image file? eg: > > CREATE TABLE SClassTable ( > ?image _________? NOT NULL, > description VARCHAR (64) DEFAULT NULL, > reference INT (5) DEFAULT NULL, > price VARCHAR(15), > PRIMARY KEY (reference), > KEY (description)
it's not a good idea to store images in databases. you're much better off storing the image in the filesystem and using the database to store metadata about the image, including description, title, copyright details, and especially the path and/or URL to the image. craig -- craig sanders <[EMAIL PROTECTED]> The next time you vote, remember that "Regime change begins at home" -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]