By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
| XML_F52E2B61-18A1-11d1-B105-00805F49916B |
|---|
| <foo><n></n></foo> |
Msg 6841 Level 16 State 1 Line 1
FOR XML could not serialize the data for node 'n' because it contains a character (0x001F) 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.