Oracle XMLType field being rewritten
Posted: 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?
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?