This server class is deprecated. You should update your application to use server class aseodbc. See Server class aseodbc.
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.
The local setting of the quoted_identifier option controls the use of quoted identifiers for Adaptive Server Enterprise. For example, if you set the quoted_identifier option to Off locally, then quoted identifiers are turned off for 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.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |