Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

BLOB

Status
Not open for further replies.

EscapeUK

Programmer
Jul 7, 2000
438
GB
I need to save an image into a SQL field of type image.

Someone mentioned BLOB.

Can anyone help
 
BLOB (Binary Large OBjects) are handled differently by different databases. But in general, you find out what "chunk" size the database wants, then feed it portions of that size of your file.

The reverse is true when reading BLOBs -- when requesting a BLOB field, you have to make several database calls, where the database feeds you chunks of your file. You have to do the work of concatenating them together again.

Chip H.
 
Let me mention the filesystem.
Avoid storing binary data in your DB if at all possible!
Suggest you stor a path to the requested image instead.

Good Luck
-Mats Hulten
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top