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:
None 
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:28] Geert Vanderkelen
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?
[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.