sp_xml_preparedocument: how to change SQL xml encoding

Question

sp_xml_preparedocument accepts an local variable declared as varchar(max) and set to xml received without xml declaration.

Default encoding is then set to UTF-8 I suppose.

When I try to change it to something like UTF-16 message

Switch from current encoding to specified encoding not supported.

If I leave it on default message

An invalid character was found in text content.

is shown.

Any suggestion?

Thx

BenMorel · Accepted Answer · 2013-12-27 15:07:03Z

2

I changed

varchar(max)

to

nvarchar(max)

and it works now...

BenMorel

37k52 gold badges208 silver badges339 bronze badges

answered Jan 31, 2011 at 12:27

user596701

213 bronze badges

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

1 Answer 1