cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Torsten Curdt <tcu...@apache.org>
Subject Re: ESQL, Oracle CLOB and encoding
Date Wed, 03 Nov 2004 17:01:02 GMT
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

Mime
View raw message