I am getting the following error when I try to parse XML.
declare @xml xml
set @xml =
<?xml version="1.0" encoding="utf-16"?>
x.value('name', 'varchar(10)') as Name
This XML is passed from a C# program.
This seems to work fine if i change the encoding from utf-16 to utf-8.
Why does the XM L parser fail with utf-16 as the default encoding?