Bug #16531 | ENUM data type bug | ||
---|---|---|---|
Submitted: | 16 Jan 2006 10:50 | Modified: | 16 Jan 2006 11:20 |
Reporter: | gurudutt | Email Updates: | |
Status: | Not a Bug | Impact on me: | |
Category: | MySQL Server | Severity: | S3 (Non-critical) |
Version: | OS: | FreeBSD (Free BSD) | |
Assigned to: | CPU Architecture: | Any |
[16 Jan 2006 10:50]
gurudutt
[16 Jan 2006 11:20]
Valeriy Kravchuk
Thank you for taking the time to write to us, but this is not a bug. Please double-check the documentation available at http://www.mysql.com/documentation/ and the instructions on how to report a bug at http://bugs.mysql.com/how-to-report.php Additional info: Please, read the manual carefully (http://dev.mysql.com/doc/refman/5.0/en/enum.html): "An ENUM is a string object with a value chosen from a list of allowed values that are enumerated explicitly in the column specification at table creation time. The value may also be the empty string ('') or NULL under certain circumstances: - If you insert an invalid value into an ENUM (that is, a string not present in the list of allowed values), the empty string is inserted instead as a special error value. This string can be distinguished from a “normal” empty string by the fact that this string has the numerical value 0. More about this later."