| Author |
Message
|
| harish.sun |
 Posted: Wed Jul 29, 2009 11:14 pm Post subject: Junk characters returned from Oracle DB |
 |
|
Newbie
Joined: 29 Jul 2009
Posts: 9
|
Hi
I am new to WMB, I used PASSTHRU to query data from Oracle DB,
But the data returned from Oracle DB is coming with some junk characters. i verified the data in oracle and the datas are proper.
Also i used the same table structure and data and created the same in DB2 and executed withe same code connecting to DB2. it works fine with DB2.
Only problem is with Oracle.
Do i need to specify any thing special during Oracle data source creation.
Thanks in advance |
|
| Back to top |
|
 |
| AkankshA |
| Posted: Wed Jul 29, 2009 11:23 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
is the data in plain english ??
whats is the code page set for oracle and broker ?
are they both in sync ?
_________________
Cheers |
|
| Back to top |
|
|
| harish.sun |
| Posted: Wed Jul 29, 2009 11:25 pm Post subject: |
|
|
Newbie
Joined: 29 Jul 2009
Posts: 9
|
Yes its in english.
How to check the code page set in oracle and broker? |
|
| Back to top |
|
|
| AkankshA |
| Posted: Wed Jul 29, 2009 11:39 pm Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
for oracle, ask your DBA
for wmb, execute mqsiservice <brokername>
_________________
Cheers |
|
| Back to top |
|
|
| harish.sun |
| Posted: Thu Jul 30, 2009 12:39 am Post subject: |
|
|
Newbie
Joined: 29 Jul 2009
Posts: 9
|
This is the output of WMB
BIPv610 en US
ucnv Console CCSID 437 dft ucnv CCSID 5348
ICUW ibm-5348_P100-1997 ICUA ibm-5348_P100-1997
Install Path = d:\IBM\MQSI\6.1
Working Path = D:\Documents and Settings\All Users\Application Data\IBM\MQSI
Component UUID = 796d8fc4-2101-0000-0080-90dd592af203
process id = 5008
broker db name = DEFBKD61
broker db userId = harish
broker db password =
queue manager = WBRK61_DEFAULT_QUEUE_MANAGER
pubsub migration = no
fastpath Queue Manager = no
configuration timeout = 300
configuration delay timeout = 60
statistics major interval = 60
ComponentType = Broker
Fixpack capability level = all (effective level 6.1.0.3)
This is the output of Oracle Parameter queried from v$nls_parameters
PARAMETER VALUE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET WE8MSWIN1252
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZH:TZM
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZH:TZM
NLS_DUAL_CURRENCY $
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE |
|
| Back to top |
|
|
| AkankshA |
| Posted: Thu Jul 30, 2009 1:49 am Post subject: |
|
|
Grand Master
Joined: 12 Jan 2006
Posts: 1494
Location: Singapore
|
while connecting to oracle, which driver are u using ?
since WMb is on windows, you shall be using MQSeries data direct 5.3 driver configured for DSN.... pls cross chk
Also WE8MSWIN1252 is not a subset of AL32UTF8 (UTF- . The 8 bit characters found in the WE8MSWIN1252 repertiore must be converted to different binary representations in UTF-8.
For 9i: http://www.oracle.com/technology/tech/globalization/pdf/mwp.pdf
_________________
Cheers |
|
| Back to top |
|
|
| smdavies99 |
| Posted: Thu Jul 30, 2009 2:20 am Post subject: |
|
|
Jedi Council
Joined: 10 Feb 2003
Posts: 6076
Location: Somewhere over the Rainbow this side of Never-never land.
|
And from memory some of the Oracle Character set stuff is fixed at the time of DB creation and can't be changed without dropping the DB and starting over again.
This might be a problem!
Many DBA's are notoriously awkward people who's first answer to any question is 'No, never, noway, nohow' 
Only joking...I was an Oracle DBA once.
_________________
WMQ User since 1999
MQSI/WBI/WMB/'Thingy' User since 2002
Linux user since 1995
Every time you reinvent the wheel the more square it gets (anon). If in doubt think and investigate before you ask silly questions. |
|
| Back to top |
|
|
| harish.sun |
| Posted: Thu Jul 30, 2009 8:50 pm Post subject: |
|
|
Newbie
Joined: 29 Jul 2009
Posts: 9
|
|
| Back to top |
|
|
|
|
