Oracle XMLType field being rewritten

Discussion of open issues, suggestions and bugs regarding LinqConnect – Devart's LINQ to SQL compatible ORM
Post Reply
iamnotcreative
Posts: 1
Joined: Mon 19 Nov 2012 22:15

Oracle XMLType field being rewritten

Post by iamnotcreative » Mon 19 Nov 2012 22:26

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
Devart Team
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: Oracle XMLType field being rewritten

Post by MariiaI » Tue 20 Nov 2012 13:17

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.

Post Reply