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