跳至主要内容

UInt8、UInt16、UInt32、UInt64、UInt128、UInt256、Int8、Int16、Int32、Int64、Int128、Int256

定长整数,带或不带符号。

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

Int 范围

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

别名

  • Int8TINYINTINT1BYTETINYINT SIGNEDINT1 SIGNED
  • Int16SMALLINTSMALLINT SIGNED
  • Int32INTINTEGERMEDIUMINTMEDIUMINT SIGNEDINT SIGNEDINTEGER SIGNED
  • Int64BIGINTSIGNEDBIGINT SIGNEDTIME

UInt 范围

  • UInt8[0 : 255]
  • UInt16[0 : 65535]
  • UInt32[0 : 4294967295]
  • UInt64[0 : 18446744073709551615]
  • UInt128[0 : 340282366920938463463374607431768211455]
  • UInt256[0 : 115792089237316195423570985008687907853269984665640564039457584007913129639935]

别名

  • UInt8TINYINT UNSIGNEDINT1 UNSIGNED
  • UInt16SMALLINT UNSIGNED
  • UInt32MEDIUMINT UNSIGNEDINT UNSIGNEDINTEGER UNSIGNED
  • UInt64UNSIGNEDBIGINT UNSIGNEDBITSET