UMG Developer (5/12/2009)
Non-printable characters blow which method up? They appear to work just fine with the method I used. (For CR, LF, and TAB anyhow.)
Try embedding CHAR(11) or CHAR(27).... 😛
[font="Courier New"]Msg 6841, Level 16, State 1, Line 1
FOR XML could not serialize the data for node 'node' because it contains a character (0x000B) 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.
[/font]
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi