|
Standard data type |
DBMS-specific physical data type |
Content |
Length |
|
Characters |
char / CHAR |
Character strings |
Fixed |
|
Variable Characters |
varchar / VARCHAR2 |
Character strings |
Maximum |
|
Long Characters |
varchar / CLOB |
Character strings |
Maximum |
|
Long Var Characters |
text / CLOB |
Character strings |
Maximum |
|
Text |
text / CLOB |
Character strings |
Maximum |
|
Multibyte |
nchar / NCHAR |
Multibyte character strings |
Fixed |
|
Variable Multibyte |
nvarchar / NVARCHAR2 |
Multibyte character strings |
Maximum |
|
Standard data type |
DBMS-specific physical data type |
Content |
Length |
|
Date |
date / DATE |
Day, month, year |
— |
|
Time |
time / DATE |
Hour, minute, and second |
— |
|
Date & Time |
datetime / DATE |
Date and time |
— |
|
Timestamp |
timestamp / TIMESTAMP |
System date and time |
— |
|
Standard data type |
DBMS-specific physical data type |
Content |
Length |
|
Binary |
binary / RAW |
Binary strings |
Maximum |
|
Long Binary |
image / BLOB |
Binary strings |
Maximum |
|
Bitmap |
image / BLOB |
Images in bitmap format (BMP) |
Maximum |
|
Image |
image / BLOB |
Images |
Maximum |
|
OLE |
image / BLOB |
OLE links |
Maximum |
|
Other |
— |
User-defined data type |
— |
|
Undefined |
undefined |
Undefined. Replaced by the default data type at generation. |
— |