tigertoolbox icon indicating copy to clipboard operation
tigertoolbox copied to clipboard

Published 20 hours ago • verified publisher icon microsoft

usp_whatsup

Open sqlserverlabs opened this issue 5 years ago • 1 comments

Failing with error

Msg 6841, Level 16, State 1, Line 1 FOR XML could not serialize the data for node 'text()' because it contains a character (0x0000) 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.

sqlserverlabs avatar Mar 23 '20 21:03 sqlserverlabs

Same error when executing against SQL Server 2012 (11.0.7001.0). It works fine in SQL Server 2019 (15.0.4188.2)

olegueret avatar Dec 09 '21 14:12 olegueret