Article ID: 155723 - View products that this article applies to.
This article was previously published under Q155723
This article has been archived. It is offered "as is" and will no longer be updated.
If dual byte character set (DBCS) data is too long to fit into a char or varchar column, the data is truncated to fit into the column. If Microsoft SQL Server uses a DBCS code page and this truncation happens right in the middle of a double-byte character, the whole double-byte character is discarded.
The following scripts demonstrate this truncation. It is assumed that the code page that applies here is a DBCS code page.
Because the truncated string is shorter than the maximum length, the char column that does not allow a null value and the char variable is padded with trailing blanks while the varchar column will not store trailing blanks.
col1 col2 ---------- ---------- SLTLTLTLTs SLTLTLTLT