[Closed] Re: ESQL, Oracle CLOB and encoding

[george georgovassilis]

Thanx a lot!
That was exactly the problem. I looked up the esql.xsl and found a bunch 
of goodies in there, including the esql:get-clob tag which does exactly 
what I want. Unfortunately it either didn't make it into the esql user 
documentation (2.1.5.1) or I need a pair of new glasses, anyhow I 
overlooked it.

On a second notice, esql:get-xml seems to build on the get-ascii tag and 
likewise scrambles UTF-8 data.

Best regards
George Georgovassilis
Torsten Curdt wrote:
george georgovassilis wrote:
Good morning Dear All
This is a re-post from the users list where unluckily I didn't find a 
solution to my question.
So, appologies for cross-posting.

I've run into trouble with my ESQL page. In detail:
I'm running an Oracle database pool and a few tables in there with 
CLOBs which contain UTF-8 strings.
The following code extracts the data quite nicely:

oracle.sql.CLOB body =  (oracle.sql.CLOB)<esql:get-object 
column="body"/>;
String xmlbody = (body.length()&gt;0? body.getSubString(1, 
(int)body.length()):"");

which returns correctly
<snip>
ÎÎ ÎÎÏÏÎÏÎ ÎÏÎÏÎ ÏÏÎÎ ÎÎÏÎÎÎÏÎÎ 'ÎÎÎÏÎ / ÎÎÎÎÎÎ'
</snip>
The much more elegant
String stripped = <esql:get-ascii column="body"/>;
however returns garbage:
<snip>
ÂÎ ÎÂÎÎÂÎÎ ÂÎÎÎÎ ÎΠÎÂÎÂÂÎÎâ 'âÂÎΠ/ âÂÂÂÎÂ'
</snip>
Is there any way I still can use the esql?

Without looking at the code esql:get-ascii implies
ascii encoding ...but you are talking about uft-8
encoding. maybe that's the problem.
Compare the esql:get-object and esql:get-ascii
implementations in the esql.xsl.
cheers
--
Torsten