tags:

views:

31

answers:

0

Is there a mechanism to search for a string within a blob data type.

I tried converting the blob to xml data type - however, i get a hex string output. Anyway to convert the hex string into meaningful ascii? I use JDBC 3.0 - so resultSet.getSQLXML().getString() method is not an option.