Thursday, May 21, 2009

Convert String to Blob and Blob to String

Convert String to Blob

String data = "hello world";
java.sql.Blob blob = org.hibernate.Hibernate.createBlob(data.getBytes());

Convert Blob to String

byte[] bdata = blob.getBytes(1, (int)blob.length());
String data1 = new String(bdata);


Anonymous said...

What if the length of blob exceeds the maxvalue for the int? Considering blob is for binary, that is possible.

Jijo Mathew said...

BLOB may exceeds the max value for int.
If the data is too large then u can use CLOB format.
if you want to store large data, use a CLOB and to store an image, use a BLOB data types.