| Author |
Retrive column of type 'image'
|
Srinivasa Raghavan
Ranch Hand
Joined: Sep 28, 2004
Posts: 1228
|
|
|
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
internet detective
Marshal
Joined: May 26, 2003
Posts: 26192
|
|
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.
|
[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
|
|
 |
|
|
subject: Retrive column of type 'image'
|
|
|
0
