Adaptive Server maps SQL datatypes to Java types (SQL-Java datatype mapping) and Java scalar types to SQL datatypes (Java-SQL datatype mapping). Table 9-3 shows SQL-Java datatype mapping.
SQL type |
Java type |
---|---|
char |
String |
varchar |
String |
nchar |
String |
nvarchar |
String |
unichar |
String |
univarchar |
String |
unitext |
String |
text |
String |
numeric |
java.math.BigDecimal |
decimal |
java.math.BigDecimal |
money |
java.math.BigDecimal |
smallmoney |
Java.math.BigDecimal |
bit |
boolean |
tinyint |
byte |
smallint |
short |
integer |
int |
bigint |
long |
unsigned smallint |
int |
unsigned int |
long |
unsigned bigint |
java.math.BigInteger |
bigint |
java.math.BigInteger |
real |
float |
float |
double |
double precision |
double |
binary |
byte[ ] |
varbinary |
byte[ ] |
image |
java.io.InputStream |
datetime |
java.sql.Timestamp |
smalldatetime |
java.sql.Timestamp |
bigdatetime |
java.sql.Timestamp |
bigtime |
java.sql.Time |
date |
java.sql.Date |
time |
java.sql.Time |
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 9-4 shows Java-SQL datatype mapping.
Java scalar type |
SQL type |
---|---|
boolean |
bit |
byte |
tinyint |
short |
smallint |
int |
integer |
long |
bigint |
float |
real |
double |
double |