SQL Server Error Msg 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 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…