How to convert CLOB to UTF8

[Nagarajan Lakshamanan]

Hi all,

We have batch job which actually runs on daily basis and produces XML with the Java code.And the XML generated is used for various purposes.
Recently the job was not executed successfully because of some special characters in XML which falls out of ANSI encoding stantands.

So we are in a situation to convert the CLOB datatype (input to Java code) to UTF8 encoded XML.
We are not to able to achieve this .

Right now the cloB data is converted to ASCII stream,which doesn't create a well formed XML based on UTF8 encoding standards .See below the code

clob xmlCLOB = (Clob)clobInfo.get("clobfield");
InputStream is = xmlCLOB.getAsciiStream();

Any thoughts on how to convert this CLOB to UTF8?

Regards,
NaG

[Paul Clapham]

Why not use getCharacterStream, then? It doesn't convert the CLOB to bytes like getAsciiStream does, it gives you a Reader.