Adaptive Server maps SQL datatypes to Java types (SQL-Java datatype mapping) and Java scalar types to SQL datatypes (Java-SQL datatype mapping). Table 8-3 shows SQL-Java datatype mapping.
The mapping of unsigned
bigint to double is an approximation;
it will not provide exact values. For exact values, convert the unsigned
bigint value to a string value when
passing it to a Java method.
Table 8-4 shows Java-SQL datatype mapping.
Java scalar type |
SQL type |
---|---|
boolean |
bit |
byte |
tinyint |
short |
smallint |
int |
integer |
long |
integer |
float |
real |
double |
double |
Copyright © 2005. Sybase Inc. All rights reserved. |
![]() |