User Documentation
Ispirer Capabilities - MySQL Migration
Pricing
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