| |
|
RSS Feed - WebSphere MQ Support
|
RSS Feed - Message Broker Support
|
  |
|
| "Umlaut" problem on database insert |
« View previous topic :: View next topic » |
| Author |
Message
|
| schroederms |
 Posted: Thu Jun 16, 2005 12:36 pm Post subject: "Umlaut" problem on database insert |
 |
|
Disciple
Joined: 21 Jul 2003
Posts: 169
Location: IA
|
I get a message off a queue. This is the message :
<TEST><TAG1>KÃœKELS</TAG1></TEST>
The CCSID is 1208 on the MQMD, the queue manager has a CCSID set tp 819, and I was told by the MQ Admin, that it had to stay at 819.
So when I create a simple flow to pull this off and insert the vale of TAG1
into a database the characters look like this in the database:
K¿¿KELS the Ü is getting converted to two characters it looks like.
Not sure where to go from here. I've tried to change the CCSID on the message MQMD to match the queue manager's CCSID of 819 and I get this:
K¿¿¿¿KELS which is even worse.
Can someone help me.
Thanks,
Mike |
|
| Back to top |
|
 |
| shalabh1976 |
| Posted: Thu Jun 16, 2005 9:08 pm Post subject: |
|
|
Partisan
Joined: 18 Jul 2002
Posts: 381
Location: Gurgaon, India
|
I am not sure but have a look here:
http://www.mqseries.net/phpBB2/viewtopic.php?t=22674
This is what is mentioned there:
| Quote: |
We were able to solve the Umla charecter from German... by making
CodedCharSetId &Properties for MQMD =819 and
CodedCharSetId &Properties for Properties = 273
|
_________________
Shalabh
IBM Cert. WMB V6.0
IBM Cert. MQ V5.3 App. Prog.
IBM Cert. DB2 9 DB Associate |
|
| Back to top |
|
|
| fschofer |
| Posted: Thu Jun 16, 2005 11:56 pm Post subject: |
|
|
Knight
Joined: 02 Jul 2001
Posts: 524
Location: Mainz, Germany
|
Hi,
try setting these environment variables in the profile of your broker user and restart your broker.
#
# entries to solve the "Umlaute" problem
#
export NLS_LANG=GERMAN_GERMANY.WE8ISO8859P1
export LANG=en_US
This helped me in a similar problem.
Greetings
Frank |
|
| 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
|
|
|
|
