SMALLINT provides 2 bytes of storage.
java.lang.Short
SMALLINT
-32768 (java.lang.Short.MIN_VALUE)
32767 (java.lang.Short.MAX_VALUE)
When mixed with other data types
in expressions, the resulting data type follows the rules shown in
See
also
Constants in the appropriate format always map to INTEGER or BIGINT, depending on their length.