When you convert from a multibyte character set to a single-byte character set, characters with no single-byte equivalent are converted to blanks.
text columns can be explicitly converted to char, nchar, unichar, varchar, univarchar, or nvarchar. You are limited to the maximum length of the character datatypes, the page size. If you do not specify the length, the converted value has a default length of 30 bytes.
