File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes XML and Related Technologies and the fly likes How to convert CLOB to UTF8 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "How to convert CLOB to UTF8" Watch "How to convert CLOB to UTF8" New topic

How to convert CLOB to UTF8

Nagarajan Lakshamanan

Joined: Sep 19, 2010
Posts: 8
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

Any thoughts on how to convert this CLOB to UTF8?

Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

Why not use getCharacterStream, then? It doesn't convert the CLOB to bytes like getAsciiStream does, it gives you a Reader.
I agree. Here's the link:
subject: How to convert CLOB to UTF8
It's not a secret anymore!