Storing images!

Storing images!

Post by sean » Wed, 08 Jul 1998 04:00:00

Sql server is the backend for the website. Can images be stored in the
Database for retrieval.

Thank you


Storing images!

Post by Bob Pfeif » Thu, 09 Jul 1998 04:00:00

You could store them using the image datatype as a BLOB, but I would
consider storing images (.jpg, .gif) in the file system and storing a
reference to them (path or URL) in the database.

Bob Pfeiff
Spectrum Technology Group, Inc.


Storing images!

Post by Neil Pik » Thu, 09 Jul 1998 04:00:00


 Yes, but the access methods a kludgy.  You're usually far better off
storing the UNC path to the image and storing the image on the

 Neil Pike MVP/MCSE
 Protech Computing Ltd


Storing images!

Post by Gianluca Hot » Thu, 09 Jul 1998 04:00:00

Quote:> Sql server is the backend for the website. Can images be stored in the
> Database for retrieval.

Yes, you can use IMAGE fields to hold your data.
Or better you can store the name in a text field
and develop the application to deal with it.

Best regards,
Gianluca Hotz                                __
Technical Service Manager at Alphasys srl   /  \/ /
MCP Windows & MCP + MVP SQL Server         / /\/ /
Currently working for Ekar spa             \ \/ /\                    \__/\ \


1. store image, or image path in DB?

Anyone with experience & opinion about whether there is any significant
advantage to storing image data directly in SQL Server instead of
storing just the *path* to image file?

The number of image files is small (hundreds, possibly), and the size of
each file is likely to be small (<50K).

Application is e-commerce, with the need to display item-images, prices,
etc. which match user's specifications.

Any experience & opinions would be appreciated.


2. DTS with stored procedures / error trapping

3. Image datatype, and storing images in SQL server

4. replication question

5. Storing images or pointers to images - advice please

6. Updating Database View using ADO

7. Storing Image into a Database image field

8. Urg: How easy to import data into SQL Server 7.0 from Access

9. Store image by using image datatype in SQL 7.0

10. Storing Images in Blobs versus Storing in Filesystem - Performance Issues

11. How to store images through stored procedures in SQL Server

12. Suggestions for storing images in SQL Server vs storing references to physical paths

13. Storing image as BLOB or only storing URL to fileshare