Sybase 12.4.2 - Manual (Page 239)

CHAPTER 5 Moving Data In and Out of Databases
219
The following table indicates the Adaptive Server Enterprise character data
types and the Adaptive Server IQ equivalents.
Table 5-13: Character data types
The following table indicates the Adaptive Server Enterprise money data types
and the Adaptive Server IQ equivalents.
Table 5-14: Money data types
The following table indicates the Adaptive Server Enterprise DATE/TIME data
types and the Adaptive Server IQ equivalents.
double precision DOUBLE
real REAL
Adaptive Server
Enterprise Datatype Adaptive Server IQ
Datatype
Notes
Adaptive Server
Enterprise Datatype Adaptive Server
IQ Datatype
Notes
char CHAR Adaptive Server IQ and Adaptive Server Enterprise character
(
char or CHAR ) datatypes are the same except that Adaptive Server
IQ can handle NULLs. If you want an Adaptive Server IQ CHAR
column to exactly match an Adaptive Server Enterprise char
column, specify Adaptive Server IQ column as NOT NULL.
Adaptive Server IQ default allows NULLs. Adaptive Server
Enterprise
char columns that allow NULLs are internally
converted to varchar .
varchar VARCHAR See above.
nchar Not supported
nvarchar Not supported See nchar notes above.
text Not supported See nchar notes above.
Adaptive Server
Enterprise Datatype Adaptive Server IQ
Datatype
Notes
money NUMERIC(19,4) money data is converted implicitly to NUMERIC(19,4) .
smallmoney NUMERIC(10,4)