Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 



SHORT/SMALLINT

Description

The SMALLINT data type is used to represent a small integer type. The value range is available is from -32,768 to +32,767.

SMALLINT |

SHORT

Remark
  • If a real number is entered for an SMALLINT type, the number is rounded to zero decimal place and the integer value is stored.
  • SMALLINT and SHORT are used interchangeably.
Example

If you specify 8934 as SMALLINT, 8934 is stored.

If you specify 34.5 as SMALLINT, 35 is stored (all digits after the decimal point are rounded).

If you specify 23467 as SMALLINT, 23467 is stored.

If you specify 89354 as SMALLINT, an error occurs (if the allowable limit is exceeded).