Hi All,
We have a requirement wherein, we want to
do database operations from WMQI, compute node / Database node
Details:
WMQI v 2.1 CSD 05
DB2 v 7.2 PF 7
OS : Windows 2000
The data comes as XML to the broker, with
encoding as UTF-8. The data also contains some Arabic characters apart from
Basic Latin.
MQ puts this data as CCSID
1208.
We noticed that when we do an
insert, the Arabic data is getting corrupted.
We tried inserting the data through java
program using JDBC, and verified that the Arabic data is getting stored
correctly.
When we tried selecting the same through
Compute Node, we found the data is corrupted.
Basically, we noticed that eventhough the
data is UTF-8 (1208), the ODBC driver is treating that as ASCII.
Do we have to do some settings when
we define ODBC DSN, to indicate that Character data will be
UTF-8?
Please give your
suggestions.
Thanks and Regards,
Rajkumar.
Torry Harris, Bangalore.
|