Scribd
Upload
45 views1 page

Integer Data Type in DBMS

Different SQL DBMS utilize various integer data types with distinct ranges and byte sizes. The document outlines the byte size and signed/unsigned ranges for TinyInt, SmallInt, MediumInt, Int/Integer, and BigInt. It also lists the supported integer data types in SQL Server, MySQL, PostgreSQL, and DB2.

Uploaded by

Nickleus Jimenez
Copyright
© Public Domain
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
45 views1 page

Integer Data Type in DBMS

Different SQL DBMS utilize various integer data types with distinct ranges and byte sizes. The document outlines the byte size and signed/unsigned ranges for TinyInt, SmallInt, MediumInt, Int/Integer, and BigInt. It also lists the supported integer data types in SQL Server, MySQL, PostgreSQL, and DB2.

Uploaded by

Nickleus Jimenez
Copyright
© Public Domain
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Integer data types in different DBMS

The different SQL DBMS uses various integer data types that differ on range of values and byte
size.

Kinds of integer datatypes in DBMS

Bytes Range(signed) Range (unsigned)


TinyInt 1 -128 to 127 0 to 255
smallInt 2 -32768 to 32767 0 to 65535
mediumInt 3 -8388608 to 8388607 0 to 16777215
int/integer 4 -2147483648 to 2147483647 0 to 4294967295
bigint 8 -9223372036854775808 to 9223372036854775807 0 to 18446744073709551615

Supported data type in Green

SQL MySql Postgres DB2


Server
inyInt
smallInt
mediumInt
int/integer
bigInt

You might also like