text and unitext 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.
When you convert from a Unicode character datatype to another character datatype, characters with no equivalent are replaced by question marks.
Copyright © 2005. Sybase Inc. All rights reserved. |