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 | 



INT/INTEGER

Description

The INTEGER data type is used to represent integers. The value range is available is from -2,147,483,648 to +2,147,483,647. SMALLINT is used for small integers, and BIGINT is used for big integers.

INTEGER |

INT

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

If you specify 8934 as INTEGER, 8934 is stored.

If you specify 7823467 as INTEGER, 7823467 is stored.

If you specify 89.8 to an INTEGER, 90 is stored (all digits after the decimal point are rounded).

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