How to insert JPG into a ASA9 table?

[sjh]

Hi, I never worked with images and database before and I'd really appreciate your help!

I need to know which data type (image, bigint?) to use for the column for storing images, and also how to use an insert statement to load the image to a table. I'm using ASA 9 database.

Thank you in advance!

 

[mrdenny]

You will want to use the IMAGE data type. This is for blob binary data.

Your insert statement will look something like this.

insert into table
(JPGCol)
values
('0x412514......')

You may want to considder saving the images to the hard drive and put putting the path to the file within the database. You tend to get better performance this way.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com