| Bug #48146 | Document LONG as synonym for MEDIUMTEXT | ||
|---|---|---|---|
| Submitted: | 19 Oct 2009 10:28 | Modified: | 19 Oct 2009 10:53 |
| Reporter: | Geert Vanderkelen | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server: Documentation | Severity: | S3 (Non-critical) |
| Version: | 5.1.39 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | datatype, doc | ||
[19 Oct 2009 10:53]
Valeriy Kravchuk
Actually, this is documented. Check http://dev.mysql.com/doc/refman/5.1/en/other-vendor-data-types.html.
Description: It would be good to document the LONG keyword being a synonym for MEDIUMTEXT. (Unless of course this is a data-type-parsing bug!?!) It does look weird.. IMHO.. A LONG sounds more an integer than a string.. How to repeat: mysql> CREATE TABLE a (id LONG); mysql> SHOW CREATE TABLE a\G *************************** 1. row *************************** Table: a Create Table: CREATE TABLE `a` ( `id` mediumtext ) ENGINE=MyISAM DEFAULT CHARSET=latin1 Suggested fix: It's not in the documentation, AFAIK. Maybe I missed it?