In this blog post, let’s learn about the error message “6841 – FOR XML could not serialize the data for node ‘%.*ls’ because it contains a character (0x%04X) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive.” in Microsoft SQL Server, the reason why it appears and the solution to fix it.
SQL Server Error Message
6841 – FOR XML could not serialize the data for node ‘%.*ls’ because it contains a character (0x%04X) which is not allowed in XML. To retrieve this data using FOR XML, convert it to binary, varbinary or image data type and use the BINARY BASE64 directive.
Reason for the Error
To be update soon…
Solution
To be update soon…