Ispirer Website Ispirer Capabilities - MySQL Migration Free Trial

MySQL Data Types - TINYINT

Versions: MySQL 5.x, 4.x and 3.23

MySQL - TINYINT
Syntax TINYINT[(m)] [UNSIGNED] [ZEROFILL]
Data 8-bit integer data
Parameters m is the display width of data (not the value range constraint), optional. If the width of the value is less than m, the value is right-padded with spaces
(applications can get this information from the result set metadata). If ZEROFILL is specified the value is right-padded with zeros
Range Signed: -128 to 127, Unsigned: 0 to 255
Storage Size 1 byte
Synonyms INT1
Standards MySQL Extension

MySQL TINYINT - Equivalents in Other Databases

Database Data Type and Conversion
Oracle NUMBER(3,0), -103-1 to 103-1
SQL Server TINYINT, 0 to 255
PostgreSQL SMALLINT, -32768 to 32767
Sybase ASE TINYINT, 0 to 255
Informix SMALLINT, -32768 to 32767
HP Neoview SMALLINT, Signed: -32768 to 32767, Unsigned: 0 to 65535
Ingres TINYINT, -128 to 127

Related Data Types in MySQL

Data Types
Integers BIGINT INT MEDIUMINT SMALLINT
Fixed-point DECIMAL(p,s) NUMERIC(p,s)
Floating-point FLOAT(p,s) REAL(p,s) DOUBLE(p,s)

All Data Types


© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.