Filter
Top Products
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)