Saving XML contents with ISO-8859-1 encoding using Entity Framework into SQL Server 2008's XML column gives encoding error

Question

I am trying to save XML content with encoding="ISO-8859-1" standalone="yes" into a SQL Server 2008 XML column. I am doing this using Entity Framework.

However doing this throws the following error

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

However when I try to save XML content with encoding UTF-16, it is saved without any error.

Does anyone have any inputs regarding this?

Community · Accepted Answer · 2017-05-23 12:30:32Z

2

The encoding width must match the datatype width

So don't send:

UTF-8 and nvarchar/xml
UTF-16 and varchar

Also see Trying to store XML content into SQL Server 2005 fails (encoding problem) whcih links to http://social.msdn.microsoft.com/forums/en-US/sqlxml/thread/d40ef582-4ffe-4f4b-b6b8-03c6c0ba1a32/

edited May 23, 2017 at 12:30

CommunityBot

11 silver badge

answered Jul 28, 2011 at 11:00

gbn

434k84 gold badges602 silver badges690 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

surajnaik Over a year ago

The datatype of the column in SQL Server 2008 is xml and that of property of corresponding class generated by Entity Framework is string. Also I am sending data with encoding ISO-8859-1.

gbn Over a year ago

@surajnaik: xml is effectively nvarchar in this case. You have to change encoding.

Collectives™ on Stack Overflow

Saving XML contents with ISO-8859-1 encoding using Entity Framework into SQL Server 2008's XML column gives encoding error

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related