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

Chapter 15: Using the Built-In Functions in Queries

Converting from one character type to another

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. Converting numbers to a character type

View this book as PDF