Converting character data to a noncharacter type  Converting numbers to a character type

Chapter 2: Transact-SQL Functions

Converting from one character type to another

When converting from a multibyte character set to a single-byte character set, characters with no single-byte equivalent are converted to question marks.

text and unitext columns can be explicitly converted to char, nchar, varchar, unichar, univarchar, or nvarchar. You are limited to the maximum length of the character datatypes, which is determined by the maximum column size for your server’s logical page size. If you do not specify the length, the converted value has a default length of 30 bytes.





Copyright © 2005. Sybase Inc. All rights reserved. Converting numbers to a character type

View this book as PDF