Oracle XMLType field being rewritten

[iamnotcreative]

Hello,

We're using LinqConnect in a VB program written using Visual Studio 2010 to talk to an Oracle database. We have a table that consists of three columns: id, status and xmltext which is an XMLType field.

We ran into a problem where the XML was being rewritten after the status field, and only the status field, was updated. Things like tag order changing, empty elements being changed from <element></element> to <element /> and characters such as Ñ being turned into their Windows-1252 equivalent. Something I found out today is that the XML isn't completely proper as it's missing <?xml version="1.0" encoding="UTF-8"?> at the top but was wondering if it's even possible LinqConnect is doing this?

[MariiaI]

LinqConnect does not change the content of the passed XMLs values. The issue with changing characters such as 'Ñ' is related to Oracle connection settings. Please try setting the "Unicode" parameter to 'true' in the used connection string.

As for the question about empty tags, please contact Oracle support for help regarding XML in Oracle.