Retrive column of type 'image'
posted 11 years ago
I have a column in MS SQL - Server database with data type 'image', but it has a chunk of text stored in a binary format. Can any one throw light on retrieving the values of this column.
Thanks & regards, Srini
MCP, SCJP-1.4, NCFM (Financial Markets), Oracle 9i - SQL ( 1Z0-007 ), ITIL Certified
posted 11 years ago
Srinivasa,
You can use rs.getBlob() or rs.getBinaryStream() to get the result. One or two databases call their binary data column "image" even though it is misleading.
You can use rs.getBlob() or rs.getBinaryStream() to get the result. One or two databases call their binary data column "image" even though it is misleading.
[OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
|
We can walk to school together. And we can both read this tiny ad:
Thread Boost - a very different sort of advertising
https://coderanch.com/t/674455/Thread-Boost-feature
|