2.2 Message Syntax

Character data, such as SQL statements, within a TDS message is in Unicode, unless the character data represents the data value of an ASCII data type, such as a non-Unicode data column. A character count within TDS is a count of characters, rather than of bytes, except when that character count is explicitly specified as a byte count.