| Author |
Message
|
| cvanmook |
 Posted: Wed Feb 16, 2005 3:06 pm Post subject: special character insert in Oracle database |
 |
|
Novice
Joined: 16 Jan 2004
Posts: 23
|
Hello,
We're trying to fill a oracle table from the MQSI v5 CSD03. Everthing is working correct except if we get an special character in our xml message we insert this in an Oracle (v9.2) table and the special character is changed in unreadable code.
If we do the same insert via an SQL session it works fine so the language etc etc on the database is ok. Already checked with our DBA's.
It is using the Driver=/usr/opt/wmqi/merant/lib/UKor818.so via de $ODBCINI file ...... maybe the ODBC connection is the problem.
Does anybody know what the problem is ...?
Thanx in advance,
Christan |
|
| Back to top |
|
 |
| jefflowrey |
| Posted: Wed Feb 16, 2005 5:32 pm Post subject: |
|
|
Grand Poobah
Joined: 16 Oct 2002
Posts: 19981
|
You don't say what OS you are running on.
But on Unix, I have seen a similar problem with Oracle data when the user that was running the process in question (it was WAS in this case) did not have the NLS_LANG environment variable set in their current environment.
_________________
I am *not* the model of the modern major general. |
|
| Back to top |
|
|
| cvanmook |
| Posted: Fri Feb 18, 2005 2:14 am Post subject: |
|
|
Novice
Joined: 16 Jan 2004
Posts: 23
|
We're running on an AIX5 system. I've tried some NLS_LANG settings in the environment but without result... the caracters in the DB changed with the different NLS_LANG but the ë "alt 137" for example isn't correct displayed....
Must we set something more or with NLS_LANG is working?
We are using the Merant Driver below.
Driver=/usr/opt/wmqi/merant/lib/UKor818.so
Thanx,
Christan. |
|
| Back to top |
|
|
| cvanmook |
| Posted: Wed Feb 23, 2005 2:29 am Post subject: Special character AMERICAN_AMERICA.WE8ISO8859P1 |
|
|
Novice
Joined: 16 Jan 2004
Posts: 23
|
I've set the NLS_LANG to AMERICAN_AMERICA.WE8ISO8859P1 but it isn't working ....
If I insert or update the record via an sqlplus session from the same machine and user it works! It seems that there is something in the merant driver or the message broker ?
Is there anyone who could help us, because we're complete ready for production except this thing .... and the time is short.
best regards,
Christan |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Wed Feb 23, 2005 3:33 am Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
|
| Back to top |
|
|
| cvanmook |
| Posted: Wed Feb 23, 2005 7:31 am Post subject: |
|
|
Novice
Joined: 16 Jan 2004
Posts: 23
|
Yes also tried but an ë becomes Sÿ it's a very strange problem....
I've tried many NLS_LANG settings but without any result.. |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Wed Feb 23, 2005 7:37 am Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
yes these things can be very tricky...
Do you have more environments where the same problem occurs?
have you compared the environments of the user using sqlplus versus the mqsi user?
_________________
Michael
MQSystems Facebook page |
|
| Back to top |
|
|
| gregh |
| Posted: Fri Feb 25, 2005 6:04 am Post subject: |
|
|
Newbie
Joined: 25 Feb 2005
Posts: 2
|
Hi,
Try setting the following environment variable and then restarting the broker:
MQSI_LOCAL_CCSID=819
_________________
Regards, Greg |
|
| Back to top |
|
|
| malammik |
| Posted: Fri Feb 25, 2005 6:42 am Post subject: |
|
|
Partisan
Joined: 27 Jan 2005
Posts: 397
Location: Philadelphia, PA
|
|
| Back to top |
|
|
| cvanmook |
| Posted: Sat Feb 26, 2005 11:47 pm Post subject: |
|
|
Novice
Joined: 16 Jan 2004
Posts: 23
|
I've set in the environment the MQSI_LOCAL_CCSID=819 and this works !!!!
Thanks,
Christan |
|
| Back to top |
|
|
| Michael Dag |
| Posted: Sun Feb 27, 2005 1:04 am Post subject: |
|
|
Jedi Knight
Joined: 13 Jun 2002
Posts: 2607
Location: The Netherlands (Amsterdam)
|
|
| Back to top |
|
|
|
|
