| Bug #48146 | Document LONG as synonym for MEDIUMTEXT | ||
|---|---|---|---|
| Submitted: | 19 Oct 12:28 | Modified: | 19 Oct 12:53 |
| Reporter: | Geert Vanderkelen | ||
| Status: | Not a Bug | ||
| Category: | Server: Docs | Severity: | S3 (Non-critical) |
| Version: | 5.1.39 | OS: | Any |
| Assigned to: | Target Version: | ||
| Tags: | datatype, doc | ||
| Triage: | Needs Triage: D2 (Serious) | ||
[19 Oct 12: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?