| Author |
Message
|
| mqwbiwf |
 Posted: Fri Aug 24, 2007 1:01 pm Post subject: oracle- euro sign issue |
 |
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
hi,
when one of our european app tries to insert a euro into the database, it's inserting arrow chars instead of Euro sign.
could someone tell me what the nls lang setting should be? i believe this setting should be applied to the broker service user id profile isn't it?
we tried :
AMERICAN_AMERICA.WE8ISO8859P1
and AMERICAN_AMERICA.UTF8 ,
but both didn't work properly when applied to broker service uids profile.
It's on Unix box.
any advice will be greatly appreciated. |
|
| Back to top |
|
 |
| Gaya3 |
| Posted: Fri Aug 24, 2007 9:34 pm Post subject: |
|
|
Jedi
Joined: 12 Sep 2006
Posts: 2493
Location: Boston, US
|
Hi
Check this links
http://dba.ipbhost.com/index.php?showtopic=6012
I suspect you have to download some fix pack for oracle..
Thanks and Regards
Gayathri
_________________
Regards
Gayathri
-----------------------------------------------
Do Something Before you Die |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Sat Aug 25, 2007 9:42 am Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
I seem to remember that 1252 is UTF-8 or Unicode with Euro symbol support...
But you might want to check it... first. 
_________________
MQ & Broker admin |
|
| Back to top |
|
|
| elvis_gn |
| Posted: Sat Aug 25, 2007 10:19 am Post subject: Re: oracle- euro sign issue |
|
|
Padawan
Joined: 08 Oct 2004
Posts: 1905
Location: Dubai
|
Hi mqwbiwf,
| mqwbiwf wrote: |
hi,
when one of our european app tries to insert a euro into the database, it's inserting arrow chars instead of Euro sign.
could someone tell me what the nls lang setting should be? i believe this setting should be applied to the broker service user id profile isn't it?
we tried :
AMERICAN_AMERICA.WE8ISO8859P1
and AMERICAN_AMERICA.UTF8 ,
but both didn't work properly when applied to broker service uids profile.
It's on Unix box.
any advice will be greatly appreciated. |
You might realize soon that the rat hole goes deeper than you initially thought....heyyy !! Matrix 
Ok, if your message flow is inserting the values, then you need to check first, if the chars are being understood in the flow correctly, for that you could use a user trace,...convert if the input is not coming in the same...using UTF-8, CCSID 1208.
Your NLS_LANG should be UTF-8 or ISO8859...(we are using UTF- .
Regards. |
|
| Back to top |
|
|
| mqwbiwf |
| Posted: Mon Aug 27, 2007 1:06 pm Post subject: |
|
|
Centurion
Joined: 21 Jul 2006
Posts: 126
|
| fjb_saper wrote: |
I seem to remember that 1252 is UTF-8 or Unicode with Euro symbol support...
But you might want to check it... first. |
tried to find the differences between the chars used in cp 819 and 1252, and found that the euro sign is missing in 819. but isn't 1252 used only for windows? can we use 1208 instead of 1252 and see if that helps? (i couldn't find the cp1208 info a lot like the others) |
|
| Back to top |
|
|
| fjb_saper |
| Posted: Mon Aug 27, 2007 5:02 pm Post subject: |
|
|
Grand High Poobah
Joined: 18 Nov 2003
Posts: 20756
Location: LI,NY
|
| mqwbiwf wrote: |
| fjb_saper wrote: |
I seem to remember that 1252 is UTF-8 or Unicode with Euro symbol support...
But you might want to check it... first. |
tried to find the differences between the chars used in cp 819 and 1252, and found that the euro sign is missing in 819. but isn't 1252 used only for windows? can we use 1208 instead of 1252 and see if that helps? (i couldn't find the cp1208 info a lot like the others) |
CCSID 1208 is UTF-8 Enjoy
_________________
MQ & Broker admin |
|
| Back to top |
|
|
|
|
