MQSeries.net :: View topic - Special Chars problem while selecting from Oracle table

MQSeries.net

Tech Exchange

Education

Certifications

Library

Info Center

SupportPacs

FAQÂ Â

Usergroups

RSS Feed - WebSphere MQ Support

RSS Feed - Message Broker Support

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Special Chars problem while selecting from Oracle table

Special Chars problem while selecting from Oracle table

« View previous topic :: View next topic »

Author

Message

golam1983

Posted: Fri Jun 27, 2008 5:12 am Post subject: Special Chars problem while selecting from Oracle table

Apprentice

Joined: 27 Jun 2008
Posts: 35

Hi,

I am querying oracle table which have lot of special characters. These special characters are mainly from SPANISH. I have tried to change the MQSI_LOCAL_CCSID to 1252 which is listed for Spanish language.

But that does not solve my problem.

Any help will be welcome...

Thanks
golam1983

fjb_saper

Posted: Fri Jun 27, 2008 7:35 am Post subject:

Grand High Poobah

Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY

First you need to know in which CCSID the string being returned by Oracle is given to you. Retrieve the data as a BLOB. Cast it to char using the correct CCSID (1208?) and you should get the right stuff.

Enjoy

_________________
MQ & Broker admin

golam1983

Posted: Fri Jun 27, 2008 7:55 am Post subject:

Apprentice

Joined: 27 Jun 2008
Posts: 35

Hi fjb_saper,

It seems your solution should be work. Initially I was selecting the colum from database table as string ...

I will let you know the result.

thanks a lot.

golam1983

Posted: Sun Jun 29, 2008 11:59 pm Post subject:

Apprentice

Joined: 27 Jun 2008
Posts: 35

Hi,

The problem solved ...

what i did...

1) SELECT RAWTOHEX(TEST) FROM test

2) cast the hex data into proper ccsid...

thanks fjb_saper....

golam1983

Posted: Mon Jun 30, 2008 12:02 am Post subject:

Apprentice

Joined: 27 Jun 2008
Posts: 35

forget to mention...i had used the 1252 codepage

Display posts from previous:

Page 1 of 1

MQSeries.net Forum Index » WebSphere Message Broker (ACE) Support » Special Chars problem while selecting from Oracle table

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