Table of Contents
Datatype - Conversion between Oracle, SQL Server and DB2
About
Datatype conversions between Java, Oracle, Microsoft SQL Server and DB2.
| Java | Oracle | Microsoft SQL Server | DB2 |
|---|---|---|---|
| java.lang.String | varchar2(255) | nvarchar(50) | varchar(255) |
| int | number(20,0) | ||
| long | number(20,0) | int | integer |
| float | number(20,5) | float | float |
| double | number(30,0) | float | double |
| byte | number(10,0) | smallint | smallint |
| char | char(1) | char | char |
| short | number(10,0) | int | integer |
| boolean | number(1,0) | bit | bit |
| java.util.Date | date | ||
| java.io.Serializable | blob | varbinary | varchar for bit data |
This conversions have been found here:
owb_home\j2ee\home\config\database-schemas
and you have also:
- informix,
- hypersonic,
- ms-access,
- postgresql,
- and sybase
