Oracle XMLType field being rewritten

Oracle XMLType field being rewritten

Postby 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?
iamnotcreative
 
Posts: 1
Joined: Mon 19 Nov 2012 22:15

Re: Oracle XMLType field being rewritten

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


Return to LinqConnect (LINQ to SQL support)