text Datatype (version 6.5)

Literal strings longer than 255 bytes are automatically converted to the text datatype. This may require stricter datatype checking in applications because a char or varchar variable cannot be directly compared to a text variable. In earlier releases of SQL Server, literal strings longer than 255 bytes were truncated and treated as a varchar datatype.