Bug #9174 there is a data type error
Submitted: 14 Mar 2005 20:27 Modified: 14 Mar 2005 20:40
Reporter: Shawn Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:n/a
Assigned to: CPU Architecture:Any

[14 Mar 2005 20:27] Shawn 
Description:
There is a documentation error at http://dev.mysql.com/doc/mysql/en/create-table.html that is suggesting that TEXT datatypes are for storing binary data.  this should not be the case, it should've been blob types instead of TEXT types.

How to repeat:
just go to the url above and preview the documentation.

Suggested fix:
Change:
| TINYBLOB [BINARY]
| BLOB [BINARY]
| MEDIUMBLOB [BINARY]
| LONGBLOB [BINARY]
| TINYTEXT 
| TEXT
| MEDIUMTEXT
| LONGTEXT
[14 Mar 2005 20:40] Paul DuBois 
The documentation is correct. BINARY has no effect
for the BLOB types. For the TEXT types, BINARY has
the effect indicated here:

http://dev.mysql.com/doc/mysql/en/string-type-overview.html