I have talked about how to preview BLOBs (Binary Large Objects) as pictures…
![A picture of The Blob stored as a BLOB](https://www.thatjeffsmith.com/wp-content/uploads/2012/01/blob2.png)
But someone on Stackoverflow asked how to read a BLOB value if it had text.
So I spooled the content of my EMPLOYEES table to a txt file, as CSV, and then loaded that to a table as a BLOB.
Then I browsed the table, double-clicked the cell…
![Check the 'text' box](https://www.thatjeffsmith.com/wp-content/uploads/2016/04/blob_text1.png)
and voila, the data being stored…
![No need to write a function to read the data in your query..unless you want to, of course.](https://www.thatjeffsmith.com/wp-content/uploads/2016/04/blob_text2.png)
Other BLOB posts:
1 Comment
Who you callin’ BLOB?