XML from file to code

[Apogee]

hi

I' reading an xml file from an external location
the encoding: <?xml version="1.0" encoding="iso-8859-1" ?>

My problem is, when I read the data from the xml element with
element.firstchild.value, some special characters disapear.

sample: <tag>abcë</tag>
element.firstchild.value returns abc

the special char "ë" is gone.

please help!

Apogee

[Oleg Tkachenko]

Apogee wrote:

I' reading an xml file from an external location
the encoding: <?xml version="1.0" encoding="iso-8859-1" ?>

My problem is, when I read the data from the xml element with
element.firstchild.value, some special characters disapear.

sample: <tag>abcë</tag>
element.firstchild.value returns abc

the special char "ë" is gone.

That may has something to do with either how you are loading document or how
you are displaying element.firstchild.value value. Provide more info about it
please.
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[SQL Server Development Team [MSFT]]

Is the "ë" character valid iso-8859-1 character? If not, there is a
posibility that it gets skipped during the decoding at load time.

-Helena Kupkova, MS

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
"Oleg Tkachenko" <oleg@NO_SPAM_PLEASEtkachenko.com> wrote in message
news:OJ*************@tk2msftngp13.phx.gbl...
Apogee wrote:

I' reading an xml file from an external location
the encoding: <?xml version="1.0" encoding="iso-8859-1" ?>

My problem is, when I read the data from the xml element with
element.firstchild.value, some special characters disapear.

sample: <tag>abcë</tag>
element.firstchild.value returns abc

the special char "ë" is gone.

That may has something to do with either how you are loading document or how
you are displaying element.firstchild.value value. Provide more info about
it
please.
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel

[Oleg Tkachenko]

SQL Server Development Team [MSFT] wrote:

Is the "ë" character valid iso-8859-1 character? If not, there is a
posibility that it gets skipped during the decoding at load time.

If that's Russian letter "Ñ‘", that's definitely not ISO8859-1, it's
ISO8859-5 instead.
--
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel