Column Types
There are a limited set of types for column data.
Unfortunately (although there is supposed to be a standard) in practice the available types are completely dependent on the vendor.
In JDBC the types are standardized and include:
INTEGER Typically 32-bit integer.
FLOAT(N) Floating point with N bits of precision.
CHARACTER(N) Fixed length string, N characters.
VARCHAR(N) Variable length string, maximum N.
BLOB A large binary object.