Data Types for Sybase IQ

The following table lists the data type support for a Sybase IQ database.
For data source specific information about the Sybase IQ database data types, see the Sybase IQ database documentation.
Data Types for Sybase IQ
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)
3
BIT
Integer that stores only the values 0 or 1.
3
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
2
LONG BINARY
Varying-length binary string.
VARBINARY(n)
2
LONG VARBIT
Arbitrary length bit arrays.
VARCHAR(n)
NCHAR(n)
NCHAR(n)
Fixed-length Unicode character string.
NCHAR(n)
2
LONG NVARCHAR(n)
Varying length Unicode character string.
NVARCHAR(n)
2
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.
Copyright © SAS Institute Inc. All rights reserved.