Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Anywhere Server - SQL Usage » Remote Data and Bulk Operations » Server classes for remote data access » JDBC-based server classes

 

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)