[Squirrel-sql-develop] AS400 query encoding

[Ahmed A. <ahm...@va...>]

  Hi,

I might not using the right list since I am not Squirrel developer, but 
I thought I could get some help here.

I am executing the following query on iSeries and it is working fine:

SELECT AS301pf.ORNAM, AS301pf.ORTLH, AS301pf.ORTLM FROM AS301pf WHERE  
AS301pf.ORNAM LIKE '%???????%'

As you can see, there are some non-Latin characters that Squirrel 
handles perfectly.

When I try executing the same query from a Java program, I get an empty 
result set. I use the same driver from JTOpen.
Is there some driver property that I should set or the Java code should 
do any encoding on the select string before executing the statement.
I wonder if someone here knows how to handle this from the Java code to 
achieve the same result as Squirrel or if you can point me to which code 
handles this in Squirrel source.

Many thanks,
Ahmed