跳到主要内容
跳到主要内容

Int | UInt 类型

ClickHouse 提供多种固定长度的整数,带符号(Int)或无符号(无符号 UInt),大小范围从一个字节到 32 个字节。

在创建表时,可以设置整数的数字参数(例如 TINYINT(8)SMALLINT(16)INT(32)BIGINT(64)),但 ClickHouse 会忽略这些参数。

整数范围

整数类型具有以下范围:

类型范围
Int8[-128 : 127]
Int16[-32768 : 32767]
Int32[-2147483648 : 2147483647]
Int64[-9223372036854775808 : 9223372036854775807]
Int128[-170141183460469231731687303715884105728 : 170141183460469231731687303715884105727]
Int256[-57896044618658097711785492504343953926634992332820282019728792003956564819968 : 57896044618658097711785492504343953926634992332820282019728792003956564819967]

无符号整数类型具有以下范围:

类型范围
UInt8[0 : 255]
UInt16[0 : 65535]
UInt32[0 : 4294967295]
UInt64[0 : 18446744073709551615]
UInt128[0 : 340282366920938463463374607431768211455]
UInt256[0 : 115792089237316195423570985008687907853269984665640564039457584007913129639935]

整数别名

整数类型具有以下别名:

类型别名
Int8TINYINTINT1BYTETINYINT SIGNEDINT1 SIGNED
Int16SMALLINTSMALLINT SIGNED
Int32INTINTEGERMEDIUMINTMEDIUMINT SIGNEDINT SIGNEDINTEGER SIGNED
Int64BIGINTSIGNEDBIGINT SIGNEDTIME

无符号整数类型具有以下别名:

类型别名
UInt8TINYINT UNSIGNEDINT1 UNSIGNED
UInt16SMALLINT UNSIGNED
UInt32MEDIUMINT UNSIGNEDINT UNSIGNEDINTEGER UNSIGNED
UInt64UNSIGNEDBIGINT UNSIGNEDBITSET