Sybase IQ Enterprise data mapping

Mapping to Sybase IQ consolidated data types

The following table identifies how SQL Anywhere and UltraLite remote data types are mapped to Sybase IQ consolidated data types. For example, a column of type LONG VARBIT on the remote database should be type LONG VARCHAR on the consolidated database.

SQL Anywhere or UltraLite data type	Sybase IQ	Notes
BIGINT	BIGINT
BIT	BIT
BINARY(n)	BINARY(n)
CHAR(n)	CHAR(n)	There are some restrictions on CHAR and VARCHAR columns over 255 bytes. For more information, see the Sybase IQ documentation.
DATE	DATE
DATETIME	DATETIME
DECIMAL(p,s)	DECIMAL(p,s)
DOUBLE	DOUBLE
FLOAT(p)	FLOAT(p)
INT	INT
LONG BINARY / IMAGE	LONG BINARY / IMAGE
LONG NVARCHAR / NTEXT		This data type is not available in IQ.
LONG VARBIT	LONG VARCHAR
LONG VARCHAR / TEXT	TEXT
MONEY	MONEY
NCHAR(n)		This data type is not available in IQ.
NVARCHAR(n)		This data type is not available in IQ.
NUMERIC(p,s)	NUMERIC(p,s)
SMALLDATETIME	SMALLDATETIME
SMALLMONEY	SMALLMONEY
ST_GEOMETRY		This data type is not available in IQ.
TIME	TIME
TIMESTAMP	TIMESTAMP
TIMESTAMP WITH TIME ZONE	VARCHAR(34)
TINYINT	TINYINT
UNIQUEIDENTIFIER	UNIQUEIDENTIFIER
UNSIGNED BIGINT	UNSIGNED BIGINT
UNSIGNED INT	UNSIGNED INT
UNSIGNED SMALLINT	SMALLINT
UNSIGNED TINYINT	TINYINT
VARBINARY(n)	VARBINARY(n)
VARBIT(n)	VARCHAR(n)
VARCHAR(n)	VARCHAR(n)	There are some restrictions on CHAR and VARCHAR columns over 255 bytes. For more information, see the Sybase IQ documentation.
XML	LONG BINARY / IMAGE

Mapping to SQL Anywhere or UltraLite remote data types

The following table identifies how Sybase IQ consolidated data types are mapped to SQL Anywhere and UltraLite remote data types. For example, a column of type DOUBLE PRECISION on the consolidated database should be type DOUBLE on the remote database.

Sybase IQ	SQL Anywhere or UltraLite data type	Notes
BIGINT	BIGINT
BINARY(n)	BINARY(n)
BIT	BIT
CHAR(n)	VARCHAR(n)
DATE	DATE
DATETIME	DATETIME
DECIMAL(p,s)	DECIMAL(p,s)
DOUBLE	DOUBLE
FLOAT(p)	FLOAT(p)
INT	INT
LONG BINARY / IMAGE	LONG BINARY / IMAGE
LONG VARCHAR / TEXT	LONG VARCHAR / TEXT
MONEY	MONEY
NUMERIC(p,s)	NUMERIC(p,s)
REAL	REAL
SMALLDATETIME	SMALLDATETIME
SMALLINT	SMALLINT
SMALLMONEY	SMALLMONEY
TIME	TIME
TIMESTAMP	TIMESTAMP
TINYINT	TINYINT
UNIQUEIDENTIFIER	UNIQUEIDENTIFIER
UNSIGNED BIGINT	UNSIGNED BIGINT
UNSIGNED INT	UNSIGNED INT
VARBINARY(n)	VARBINARY(n)
VARCHAR(n)	VARCHAR(n)

Discuss this page in DocCommentXchange.