SQLWays Product Page - Migration to MySQL
Free Evaluation
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
| Oracle | SQL Server | IBM DB2 | MySQL | PostgreSQL | Sybase ASE | Sybase ASA | Informix DS | Teradata | HP Neoview | Interbase/Firebird |
Discussion