Image Data Type

[Linto]

Hi

I am developing one application where the user can configure the icons of some tree nodes.

The user will provide the BMPs of the application using some BMP files. I want to store this BMP files in Database using Image data type .. or any other data type ??

How I will store this image in databse ? How I will retrieve this image ?

My front-end application is VC++. using ADO....

Thanks in advance

Linto

 

[rajeevnandanmishra]

Hi Linto,
Though you can define column with Image datatype, i do not recommend you to go with that.
Instead, i suggest you to store the BMP file in a relative path (example ..system32\bmp or ..Application\bmp or ...) and store this full path+name in your database in a varchar column.
This will help you as when showing the BMP anywhere, you know the Path+Name and can pass this value.

Hope it will move you in right direction.