Retrive column of type 'image'

Ranch Hand

Posts: 1228

posted 12 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

Jeanne Boyarsky

author & internet detective

Posts: 39129

723

I like...

posted 12 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.

[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

All of the world's problems can be solved in a garden - Geoff Lawton. Tiny ad:

RavenDB is an Open Source NoSQL Database that’s fully transactional (ACID) across your database

https://coderanch.com/t/704633/RavenDB-Open-Source-NoSQL-Database

Retrive column of type 'image'

Similar Threads