conversion between CLOB/BLOB and String

[Kenny Xu]

hello,every one.
how to convert CLOB/BLOB of java API to String,
and String to CLOB/BLOB conversion?

[Michael Morris]

Moving this to the JDBC forum.

[Jeanne Boyarsky]

Kenny,
To get a String from a blob/clob, you can use blob.getBinaryStream() or clob.getAsciiStream(). It's just like reading from a file.
Creating a blob/clob can be done using the set versions of these methods. Many drivers also provide a constructor that takes a String parameter for convenience.