• Since the encoding in the header is marked as utf-8, you will have to convert the nvarchar to varchar before converting to XML, SQL Server cannot switch the encoding implicitly.
    😎