Euro € Parsing Problem with 9ias

Hi all,
I'm having a problem with an XML parsing. I'm taking an incoming mail and using java stored in the DB i get hold of an XML attachment to an email an begin parsing it with oracle.

The problem is that when the XML file contains a euro symbol, the parser crashes. I  have isolated it as being the euro € symbol, as when it is removed, the XML file is parsed perfectly. Below is the v$nls_parameters table for the database i'm using.

NLS_LANGUAGE                        ENGLISH

NLS_TERRITORY                        IRELAND

NLS_CURRENCY                        $

NLS_ISO_CURRENCY                  IRELAND

NLS_NUMERIC_CHARACTERS            .,

NLS_CALENDAR                        GREGORIAN

NLS_DATE_FORMAT                  DD-MON-RR

NLS_DATE_LANGUAGE                  ENGLISH

NLS_CHARACTERSET                  WE8MSWIN1252

NLS_SORT                              BINARY

NLS_TIME_FORMAT                        HH12:MI:SSXFF AM

NLS_TIMESTAMP_FORMAT                  DD-MON-RR HH24:MI:SSXFF

NLS_TIME_TZ_FORMAT                  HH12:MI:SSXFF AM TZR

NLS_TIMESTAMP_TZ_FORMAT            DD-MON-RR HH24:MI:SSXFF TZR

NLS_DUAL_CURRENCY                  €

NLS_NCHAR_CHARACTERSET            AL16UTF16

NLS_COMP                              BINARY

NLS_LENGTH_SEMANTICS                  BYTE

NLS_NCHAR_CONV_EXCP                  FALSE

Any suggestions would be greatly appreciated, and thanks in advance.
LVL 1
g00334120Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

petmagdyCommented:
In case of special characters into XML tag values use ! [CDATA like this:

<language-name>
 <![CDATA[€]]>
</language-name>



0
g00334120Author Commented:
Not to reveal my ignorance but could you be a little more specific please, the € symbol is contained in the data between tags, where should i place

<language-name>
 <![CDATA[€]]>
</language-name>

Thanks.
0
petmagdyCommented:
Yes I know u mean data between tags please try it and lets see
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

g00334120Author Commented:
No luck petmagdy,
Any other suggestions?
Thanks.
0
petmagdyCommented:
yes instead of € insert &#x20AC
0
g00334120Author Commented:
I'll try that thanks. The laptop that DB is on is currently out of my possession. I'll let you know as soon as get it back.
Thanks.
0
radical_mitCommented:
one other idea ,I had, a problem but with Swiss letters, was to change the NLS_LANG oracle settting to
WE8ISO8859P1

this fixed my äöé problem as well as thje € symbol one. maybe this helps

0
g00334120Author Commented:
Cheers,
I'll give that a try too.
0
g00334120Author Commented:
Sorry for the delay,
Still no luck.
0
petmagdyCommented:
ahhhh you don't get my point i mean to replace the euro sign (€) with the Hexadecimal value (&#x20AC) inside the XML iteself not the v$nls_parameters table
0
g00334120Author Commented:
No, i did that and had no joy. It just complained about more illegal characters. Could it be a problem with the 9i xml parser?
0
petmagdyCommented:
Ok it seems u need to encode url XML as UTF-16

u still put &#x20AC  or &#8364 in the xml,

see the accepted answer at this thread URL:

http://www.experts-exchange.com/Web/Web_Languages/XML/Q_20302545.html
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Java App Servers

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.