While researching some odd behavior in SQL Server Management Studio (SSMS) I ran across something even stranger. I was testing the effect of character 0 (sometimes referred to as “NUL”) in the “Messages” tab. For those who have not worked with the C programming language (or similar languages), character 0 (usually indicated by the
\0escape sequence) is the “null terminator” for strings. Meaning, this character marks the end of this string and anything after it should not be displayed.
In Solomon’s usual fashion, you get a thorough testing of the scenario.