cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Peter Velichko" <>
Subject esql:get-ascii
Date Thu, 17 Apr 2003 18:54:08 GMT
Hello all,

My enviroment is jdk1.4.1, tomcat 4.1.18, cocoon 2.0.4, oracle 8.1.7

My DB contains cyrillic symbols in CLOB and in VARCHAR fields.
When I extract the data from VARCHAR by <esql:get-text /> my data is
OK. But when I try to extract the data from CLOB by <esql:get-ascii />
the cyrillic symbols are incorrect.

My CLOB content:
"The site development has been begun!

The "sitemap.xmap" snippet:
<map:match pattern="my_match">
  <map:generate src="docs/test.xsp" type="serverpages"/>
  <map:serialize type="xml"/>

The "test.xsp":
<?xml version="1.0"?>
<xsp:page language="java" 
	  select t.myclob, t.myvarchar
	  from mytesttable t
	  where t.document_id=2
	  <table border="1">
		<td><esql:get-ascii column="myclob"/></td>
		<td><esql:get-string column="myvarchar"/></td>
	<esql:no-results><p>Sorry, no results!</p></esql:no-results>

The situation is reproduced either my DB is created with characterset windows-1251 or with
characterset UTF-8.

Could you please explain to me what is wrong?  

Best regards,
Peter Velychko

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message