| 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 |
|
| Back to top |
|
 |
| fjb_saper |
| Posted: Fri Jun 27, 2008 7:35 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20763
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 |
|
| Back to top |
|
|
| 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. |
|
| Back to top |
|
|
| 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....  |
|
| Back to top |
|
|
| 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 |
|
| Back to top |
|
|
|
|
