This server class is deprecated. You should update your application to use 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.
NotesThe 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.
Data type conversions: JDBC and Adaptive Server EnterpriseWhen you execute 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) |
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |