ASG
IBM
Zystems
Cressida
Icon
Netflexity
 
  MQSeries.net
Search  Search       Tech Exchange      Education      Certifications      Library      Info Center      SupportPacs      LinkedIn  Search  Search                                                                   FAQ  FAQ   Usergroups  Usergroups
 
Register  ::  Log in Log in to check your private messages
 
RSS Feed - WebSphere MQ Support RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Code Conversion from Database Select

Post new topic  Reply to topic
 Code Conversion from Database Select « View previous topic :: View next topic » 
Author Message
wischlei
PostPosted: Thu Jan 20, 2005 1:07 am    Post subject: Code Conversion from Database Select Reply with quote

Novice

Joined: 11 Feb 2004
Posts: 21
Location: Germany
Hi,

I have got a problem with special characters in the result set of a database select. When I use the select statement without columns that contain special characters everthing is ok, but as soon as I include the columns that contain german 'umlaute' I get a BIP 2135 conversion error ( The User Trace shows that the problem occurs exactly when processing the first result row containing special characters.)

What can I do?
_________________
Winfried Schleipen
Back to top
View user's profile Send private message
wischlei
PostPosted: Thu Jan 20, 2005 5:40 am    Post subject: Solved! Reply with quote

Novice

Joined: 11 Feb 2004
Posts: 21
Location: Germany
I got the solution from a colleague:
If you set the environment variable
MQSI_LOCAL_CCSID in the .profile of the broker user
you can switch the encoding. (We use CCSID 819 for DB, Broker and QM)
_________________
Winfried Schleipen
Back to top
View user's profile Send private message
martinrydman
PostPosted: Fri Jan 21, 2005 12:19 am    Post subject: Reply with quote

Centurion

Joined: 30 Jan 2004
Posts: 139
Location: Gothenburg, Sweden
Hi,

Where can I find more info on this one. I'm running WBIMB 5.0 and searched thru all docs, but didn't get a single hit.

Where else to look?

/Martin
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic  Reply to topic Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Code Conversion from Database Select
Jump to:  



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
Protected by Anti-Spam ACP
  
 


Theme by Dustin Baccetti
Powered by phpBB © 2001, 2002 phpBB Group

Copyright © MQSeries.net. All rights reserved.