basically it depends on your database server, common datatype with descriptions are below
|
Data type
|
Data type name
|
Description
|
|
ALN
|
Alphanumeric characters, mixed case
|
Maximum length depends on the database:
Oracle = 4000 characters
SQL Server = 8000 characters
DB2® = 32672 characters
|
|
AMOUNT
|
Decimal number, used for currency
|
|
|
BIGINT
|
Big integer
|
|
|
|
|
|
|
BLOB
|
Binary large object
|
Stores JPEG, movies, or PDF files in single records inside
the database instead of in external files.
|
|
CLOB
|
Character large object
|
|
