BLOBs are very large variable binary or character data, typically documents (.txt, .doc) and pictures (.jpeg, .gif, .bmp), which can be stored in a database. In SQL Server, BLOBs can be text, ntext, or image data type.
BLOB data can either be stored inside the database or in the OS file system. A typical example of data stored on the filesystem is product brochure in PDF format or PowerPoint presentations or very large images.
We are adding new commands to allow you to take advantage of reading and writing BLOB types either to the database or to the file system.
New BLOB Commands
- LOB_WRITE
- LOB_APPEND
- LOB_LENGTH
- LOB_ERASE
- LOB_READ
- LOB_TRUNCATE
- LOB_LOADFROMFILEExamples of how to use these new commands will be posted.
Tags: LOB