Hello

I am having really strange problems with inserting xml into an xml field in sql server 2005.

I have an generated xml string that I insert into the database. The declaration is:

<?xml version="1.0" encoding="utf-16" standalone="yes"?>

This inserts fine.

When I call it back to edit it and then try reinserting it I get this error:

XML parsing: line 1, character 38, unable to switch the encoding

If I try changing the encoding to utf-8 it works.

I cannot work out whats going on because it works fine the first time and even if I try inserting it again when its identical it gives the error?

I am not sure if this is llbl or something I'm doing, so I thought I'd check if you could shed any light as I can't seem to find an answer?

Thanks

Bex

Hi Bex, you should read this thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=9748

daelmo wrote:

Hi Bex, you should read this thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=9748

Hi!

Unfortunately I have already found this post and it did not help!

Unfortunately I have already found this post and it did not help

So what have you tried and what were the outcomes?

I am sorry for the delay in responding to this post, I have found the only way to insert xml into our DB was by removing the declaration. It is an SQL Server thing and not an LLBL one. There were many fixes about but none worked for us.

Thank you for your help.