bigint
This type is used to represent 64-bit signed integers.
This section describes the attribute types for a table.
Not all JDBC attributes types are implemented by all databases. Using an unsupported type will result in errors during table creation. In addition, databases often implement types in slightly different ways, so the descriptions below may not be accurate in all cases.
bigint
This type is used to represent 64-bit signed integers.
integer
This type is used to represent 32-bit signed integers.
smallint
This type is used to represent 16-bit signed integers.
tinyint
This type is used to represent 8-bit integers that may be signed or unsigned.
bit
This type is used to represent an integer with a value of 1 (True) or 0 (False).
decimal
This type is used to represent fixed precision and scale numeric data with at least the specified precision.
numeric
This type is used to represent fixed precision and scale numeric data with exactly the specified precision.
double
This type is used to represent 64-bit floating precision numbers.
real
This type is used to represent 32-bit floating precision numbers.
date
This type is used to represent dates.
time
This type is used to represent times.
timestamp
This type is used to represent date and time data.
char
This type is used to represent fixed-length character data.
varchar
This type is used to represent variable-length character data.
clob
This type is used to represent large amounts of variable-length character data.
nchar
This type is used to represent fixed-length international character data.
nvarchar
This type is used to represent variable-length international character data.
nclob
This type is used to represent large amounts of variable-length international character data.
binary
This type is used to represent fixed-length binary data.
varbinary
This type is used to represent variable-length binary data.
blob
This type is used to represent large amounts of variable-length binary data.