Hi,
On a new install of db2 v8 (ccsid 37) , we enter the following query in a java app on a browser :
select '\]' , hex('\]') as test from table1
union
select description as chars, hex(description) as test from table1.
and the ] x'BB is being changed to ! x'5A' .This error only happens when the ] is harcoded like above .If its entered by a host var then the ] is displayed ] X'BB' . The java package is bound using encoding(37) , the sccsid id 37 . I have checked the Unicode images . The manuals say that the Java App should pick up the ccsid of the table .The table is ccsid 37 . anyone come across this problem ?we are using the legacy driver .
Thanks in advance
regards.
claudia

Reminder: before executing the query DB2zOS converts the SQL to
unicode!!!!!! So your \] will be converted too. This might be a clue!

crispn (AT) br (DOT) ibm.com wrote:

I do not think you have to bind your app ccsid(37), the ccsid you bind
with should reflect the environment it runs - isn' that 1040 WAS uss.

none wrote: