Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Retrive column of type 'image'

 
Srinivasa Raghavan
Ranch Hand
Posts: 1228
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34095
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic