Question Locked

storage of images in database

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i want to ask th question that
how should i store gif,bmp etc. images in sql server 2000
its an urgent requirement

2 replies

by tony hopkinson

is you shouldn't, you should store a url to it.
However, you need a blob type column (image is suitable data type.
Then you need a Utility to get them in there.
Usual method is to pick the image file, loadit into a stream, open a query, insert / update stream it into the blobfield and then post.
Note if you are storing differentypes of images and you don't want the oiginal file name, it would be wise to store the file extension as well.

This discussion is closed to new replies.