Server class asejdbc

A server with server class asejdbc is a Sybase SQL Server and Adaptive Server Enterprise (version 10 and later) server. No special requirements exist for the configuration of an Adaptive Server Enterprise data source.

Notes

The local setting of the quoted_identifiers option controls the use of quoted identifiers for Adaptive Server Enterprise. For example, if you set the quoted_identifiers option to Off locally, then quoted identifiers are turned off for Adaptive Server Enterprise.

Data type conversions: JDBC and Adaptive Server Enterprise

When you issue a CREATE TABLE statement, SQL Anywhere automatically converts the data types to the corresponding Adaptive Server Enterprise data types using the following data type conversions.

SQL Anywhere data type	Adaptive Server Enterprise default data type
BIT	bit
TINYINT	tinyint
SMALLINT	smallint
INT	int
INTEGER	integer
DECIMAL [defaults p=30, s=6]	numeric(30,6)
DECIMAL(128,128)	not supported
NUMERIC [defaults p=30 s=6]	numeric(30,6)
NUMERIC(128,128)	not supported
FLOAT	real
REAL	real
DOUBLE	float
SMALLMONEY	numeric(10,4)
MONEY	numeric(19,4)
DATE	datetime
TIME	datetime
TIMESTAMP	datetime
SMALLDATETIME	datetime
DATETIME	datetime
CHAR(n)	varchar(n)
CHARACTER(n)	varchar(n)
VARCHAR(n)	varchar(n)
CHARACTER VARYING(n)	varchar(n)
LONG VARCHAR	text
TEXT	text
BINARY(n)	binary(n)
LONG BINARY	image
IMAGE	image
BIGINT	numeric(19,0)

Discuss this page in DocCommentXchange.
Send feedback about this page using email.