XML error in files for Ch 3 XML validation exercise
I was trying to do the first part of the XML validation task exercise in Chapter 3. Using the all good XML input. I kept getting the following error in the validation task:
There is no Unicode byte order mark. Cannot switch to Unicode.
I tried several things including the encoding="utf-16" in the xml version in the XSD file. I tried utf-8 as well. The only thing that worked was removing the encoding="utf-16" from the input XML files.
Running on SQL Server 2016 using the SQL 17 CTP SSDT.