Ispirer Website Ispirer Capabilities - MySQL Migration Free Trial

MySQL Data Types

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

Data Type Parameters and Range
Character Data Types
CHAR(n) - Fixed-length character data 0 ⇐ n ⇐ 255, default is 1
NCHAR(n) - Fixed-length character data in UTF8 0 ⇐ n ⇐ 255, default is 1
VARCHAR(n) - Variable-length character data 1 ⇐ n ⇐ 65535/charsize, n is mandatory
NVARCHAR(n) - Variable-length character data in UTF8 1 ⇐ n ⇐ 21845, n is mandatory
TINYTEXT - Variable-length character data 255 bytes
TEXT(n) - Variable-length character data 65555 bytes
MEDIUMTEXT - Variable-length character data 16,777,215 (224 – 1) bytes
LONGTEXT - Variable-length character data 4G (232 – 1) bytes
Integer Data Types
BIGINT - 64-bit integer data Signed: -263 to 263-1, Unsigned: 0 to 264-1
INT, INTEGER - 32-bit integer data Signed: -231 to 231-1 (2G), Unsigned: 0 to 232-1 (4G)
MEDIUMINT - 24-bit integer data Signed: -215 to 215-1 (8,388,607), Unsigned: 0 to 216-1 (16,777,215)
SMALLINT - 16-bit integer data Signed: -32768 to 32767, Unsigned: 0 to 65535
TINYINT - 8-bit integer data Signed: -128 to 127, Unsigned: 0 to 255
Decimal Data Types
DECIMAL(p,s), NUMERIC(p,s) - Fixed-point numeric data 1 ⇐ p ⇐ 65, default is 10; 0 ⇐ s ⇐ 30, default is 0
Floating-Point Data Types
FLOAT(p,s) - Floating-point numeric data -3.402E+38 to -1.1754E-38, 0, and 1.175E-38 to 3.402E+38
REAL(p,s) - Floating-point numeric data Synonym for FLOAT or DOUBLE depending on REAL_AS_FLOAT option
DOUBLE(p,s) - Floating-point numeric data -1.797E+308 to -2.2254E-308, 0, and 2.225E-308 to 1.797E+308
Date and Time Data Types
DATE - Date data (year, month and day) January 01, 1000 to December 31, 9999
TIME - Time data (hours, minutes and seconds) -838:59:59 to 838:59:59
DATETIME - Date and time data (year, month, day,
hours, minutes and seconds)
January 01, 1000 00:00:00 to December 31, 9999 23:59:59
TIMESTAMP - Auto-updated date and time data (year, month, day,
hours, minutes and seconds)
January 01, 1970 00:00:01 to January 01, 2038 23:59:59
YEAR - Year data 4 digit format: 1901 to 2155 and 0; 2 digit format: 70 to 69 (1970 to 2069)
Binary Data Types
BINARY(n) - Fixed-length binary data 0 ⇐ n ⇐ 255, default is 1
VARBINARY(n) - Variable-length binary data 1 ⇐ n ⇐ 65535, n is mandatory
TINYBLOB - Variable-length binary data 255 bytes
BLOB(n) - Variable-length binary data 65555 bytes
MEDIUMBLOB - Variable-length binary data 16,777,215 (224 – 1) bytes
LONGBLOB - Variable-length binary data 4G (232 – 1) bytes
Others Data Types
BOOL, BOOLEAN - Boolean data -128 to 127 and NULL
BIT(n) - Bit array 1 ⇐ n ⇐ 64, default is 1
ENUM - Enumeration data 65535 distinct values
SET - Set data 64 values

Data Types in Other Databases


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