| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| Character conversion problems in DB inserts on AIX |
« View previous topic :: View next topic » |
| Author |
Message
|
| aq |
 Posted: Mon Feb 21, 2005 8:55 am Post subject: Character conversion problems in DB inserts on AIX |
 |
|
Apprentice
Joined: 20 Dec 2001
Posts: 47
|
Hi
I have problem with two WBIMB 5 (csd04) flows on AIX platform, both flows do DB inserts to DB2 (ver. 8.2, located in another AIX machine). First flow is using DataInsert node and second is calling DB2 stored procedure using PASSTHRU statement).
The problem is that scandinavian characters are corrupted if the database insert is done from the flow on AIX (for example "Ä" --> "Ã?").
If I put & get the same message to/from queue using MQJExplorer or RFHc util everything looks fine, the scandinavian characters stay OK. So I would think that this is not WMQ issue.
Also if I start the DB2 client in WBIMB AIX machine and make stored procedure call (with scands in parameter), the scandinavian letters are stored correctly in DB2. Which makes me think that the DB2 client configuration is OK on AIX ?
In the Windows environment both flows are working fine.
Any ideas what I should check, or what might be causing this ?
Regards,
aq |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Mon Feb 21, 2005 10:11 am Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
This could be an issue with the NLS_LANG environment variable not being set in the AIX broker runtime...
Although I don't know if DB2 uses NLS_LANG, or some other such to indicate if national language services should be used or not.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| aq |
| Posted: Mon Feb 28, 2005 4:33 am Post subject: |
|
|
Apprentice
Joined: 20 Dec 2001
Posts: 47
|
|
| Back to top |
|
|
|
|
|
| |
|
Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
|
|
