How do I store images in SQL table?

[MELc]

I've added an image column but I don't know how to store an image into the column. Please help.

 

[mkuan]

The way I used to do it was saving the file path of images in a column, then retrieve the file path from the column when needed.

Anyone has a better idea?


Min.

 

[rt63]

Normally you will be doing it thru an application written in say VB or PowerBuilder etc.

I have done this in PB and can tell u how it can be done thru that.

PB provides for blob (binary large object) variables. You can open a file and read its contents into such a variable. PB also provides an interface to ODBC drivers to send this data thru a special update statement called UPDATEBLOB

UPDATEBLOB table
set image_column = :blob_variable

Only requirement is that the ODBC connection should be set with autocommit = true mode

I have seen image control in VB, where you can define the image file path and the image control can be mapped to a datasource/data column. I guess, one should be able to insert/update using such a control in a VB app. Probably you will need to explore on this..

RT

 

[tlbroadbent]

Check out the following resources.

http://msdn.microsoft.com/library/en-us/tsqlref/ts_wa-wz_2odw.asp

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ua-uz_6i2c.asp

http://msdn.microsoft.com/library/en-us/tsqlref/ts_ta-tz_3zaq.asp

Tek-Tips thread183-32427

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q173308

http://www.windows2000faq.com/Articles/Index.cfm?ArticleID=14084

http://www.mssqlcity.com/Articles/KnowHow/Textcopy.htm

http://www.sqlteam.com/item.asp?ItemID=986

http://vyaskn.tripod.com/programming_faq.htm#q5

http://www.4guysfromrolla.com/webtech/060100-1.shtml

Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.