ESQL problem

[Leszek Gawron]

I have encountered something strange concerning ESQL. I am using Pervasive
database. This is a ESQL code snippet:
<esql:connection>
    <esql:pool>symfonia</esql:pool>
    <esql:execute-query>
        <esql:use-limit-clause>pervasive</esql:use-limit-clause>
        <esql:query>select * from xt where kod like  '%Å%'</esql:query>
        <esql:results>
            <esql:row-results>
                <row>
                    <esql:get-columns/>
                    <xsp:logic>
                        String test = <esql:get-string column="kod"/>;
                        getLogger().error( test );
                    </xsp:logic>
                </row>
            </esql:row-results>
        </esql:results>
    </esql:execute-query>
</esql:connection>

If you have a strange character in select statement - that's OK - it's a
polish letter. 
The problem is: the query does not output any data.

The same written in JDBC (off cocoon):

PreparedStatement stmt = conn.prepareStatement("select * from xt where kod like 
'%Å%'");
stmt.execute();

ResultSet rs = stmt.getResultSet();

while ( rs.next() ) {
        System.out.println( rs.getString( "kod" ) );
}                       

works just fine. 

I have checked the xsp java generated source - the polish letter is encoding
using the same byte value so I do not get it what makes the difference.

Comments anyone ? 
        lg


-- 
            __
         | /  \ |        Leszek Gawron            //  \\
        \_\\  //_/       [EMAIL PROTECTED]           _\\()//_
         .'/()\'.     Phone: +48(501)720812     / //  \\ \
          \\  //  recursive: adj; see recursive  | \__/ |


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]