I'm tryin to read an XML file created by Oracle into SQL Server.
Oracle creates a file using the "WE8ISO8859P1" character set : ISO-8859-1.
I need to read the file using UTF-8.
The code I'm using to read the file is:
objDSXML.ReadXml(sFilename)
where sFileName is the full path of the file.
I get the error : Invalid byte was found at byte index XXXX
Is there some way I can convert the file in dotNet without using the
advanced save functionality.
Need a way to convert it using code, as this has to be automatic.
Any ideas would be warmly welcomed,
thanks.
> Oracle creates a file using the "WE8ISO8859P1" character set : ISO-8859-1.
> I need to read the file using UTF-8.
How come? If the file is ISO8859-1 encoded, it must be parsed accordingly.
> I get the error : Invalid byte was found at byte index XXXX
Sounds like your file is invalid. Check out encoding declarartion in XML
declaration. It must reflects real document encoding.
> Is there some way I can convert the file in dotNet without using the
> advanced save functionality.
> Need a way to convert it using code, as this has to be automatic.
Convert to what?

Signature
Oleg Tkachenko
http://www.tkachenko.com/blog
Multiconn Technologies, Israel