Getting some junk characters while reading from the oracle BLOB column.
681859Mar 25 2011 — edited Mar 28 2011 Hi All,
I have a csv loaded into the oracle blob column and I am reading it in my Java application using the JDBC code. Following is my code
rs.next();
Blob attBlob = rs.getBlob(1);
InputStream is = attBlob.getBinaryStream();
BufferedInputStream bis = new BufferedInputStream(is, 535000);
InputStreamReader isr = new InputStreamReader(bis);
lnr = new LineNumberReader(isr);
when I read the lines from line number reader I am getting some junk charactes for £ symbol. I have saved the blob data from the pl/sql developer and can see £ there.
Am I doing something wrong in reading the lines ?
Any help would really be appreciated.
Thank you,
K.