|
Data Type Definition
Keyword1
|
Sybase IQ Data Type
|
Description
|
Data Type Returned
|
|---|---|---|---|
|
BIGINT
|
BIGINT
|
64-bit integer.
|
BIGINT
|
|
BINARY(n)
|
BINARY(n)
|
Fixed-length binary
string.
|
BINARY(n)
|
|
BIT
|
Integer that stores
only the values 0 or 1.
|
||
|
CHAR(n)
|
CHAR(n)
|
Varying-length character
string.
|
VARCHAR(n)
|
|
DATE
|
DATE
|
Date values.
|
DATE
|
|
DECIMAL|NUMERIC(p,s)
|
DECIMAL(p,s)
|
Signed, exact, fixed-point
decimal number.
|
DECIMAL(p,s)
|
|
DOUBLE
|
DOUBLE
|
Double-precision floating-point
number.
|
DOUBLE
|
|
FLOAT(p)
|
FLOAT(p)
|
Floating-point number.
|
FLOAT(p)
|
|
INTEGER
|
INTEGER
|
32-bit integer.
|
INTEGER
|
|
LONG BINARY
|
Varying-length binary
string.
|
VARBINARY(n)
|
|
|
LONG VARBIT
|
Arbitrary length bit
arrays.
|
VARCHAR(n)
|
|
|
NCHAR(n)
|
NCHAR(n)
|
Fixed-length Unicode
character string.
|
NCHAR(n)
|
|
LONG NVARCHAR(n)
|
Varying length Unicode
character string.
|
NVARCHAR(n)
|
|
|
MONEY
|
Fixed-point decimal
number that stores monetary data.
|
DOUBLE
|
|
|
NVARCHAR(n)
|
NVARCHAR(n)
|
Varying-length Unicode
character string.
|
NVARCHAR(n)
|
|
REAL
|
REAL
|
Floating-point number.
|
REAL
|
|
SMALLINT
|
SMALLINT
|
16-bit integer.
|
SMALLINT
|
|
TIME(p)
|
TIME(p)
|
Time value.
|
TIME(p)
|
|
TIMESTAMP(p)
|
TIMESTAMP(p)
|
Date and time value.
|
TIMESTAMP(p)
|
|
TINYINT
|
TINYINT
|
Unsigned 8-bit integer.
|
TINYINT
|
|
VARBINARY(n)
|
VARBINARY(n)
|
Varying length binary
string.
|
VARBINARY(n)
|
|
VARCHAR(n)
|
CHAR(n)
|
Varying-length character
string.
|
VARCHAR(n)
|
| 1The CT_PRESERVE= connection argument, which controls how data types are mapped, can affect whether a data type can be defined. The values FORCE (default) and FORCE_COL_SIZE do not affect whether a data type can be defined. The values STRICT and SAFE can result in an error if the requested data type is not native to the data source, or the specified precision or scale is not within the data source range. | |||
| 2The Sybase IQ data type cannot be defined, and when data is retrieved, the native data type is mapped to a similar data type. | |||
| 3The Sybase IQ data type cannot be defined or retrieved. | |||