Ispirer Website Ispirer Capabilities - MySQL Migration Free Trial

MySQL Data Types - ENUM

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

MySQL - ENUM
Syntax ENUM('value1', 'value2', …)
Data Enumeration data is a string object that can have only one value from the list, NULL or the special '' error value
Range Maximum 65,535 distinct values
Internals ENUM is represented internally as integers
Standards MySQL Extension

MySQL ENUM - Equivalents in Other Databases

Database Data Type and Conversion
Oracle VARCHAR2(n) or NUMBER(n,0) with CHECK constraint
SQL Server VARCHAR(n) or an integer with CHECK constraint
PostgreSQL VARCHAR(n) or an integer with CHECK constraint
Sybase ASE VARCHAR(n) or an integer with CHECK constraint

All Data Types


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