Database vendors sometimes use different names for similar data types. The table that follows shows the names used in this document and the equivalents used by various database vendors.
This Guide | Oracle | MS-SQL | DB2 | MySQL |
---|---|---|---|---|
char | char | char | char | char |
varchar | varchar2 | varchar | varchar | varchar |
one-digit | number(1,0) | tinyint | numeric(1,0) | tinyint |
tinyint | number(3,0) | tinyint | numeric(3,0) | tinyint |
smallint | number(5,0) | smallint | smallint | smallint |
integer | number(10,0) | integer | integer | integer |
bigint | number(19,0) | bigint | bigint | bigint |
numeric | number | numeric | numeric | numeric |
datetime | date | datetime | timestamp | datetime |
timestamp | timestamp | datetime | timestamp | datetime |