MySQL Question

[Frank Wiles]

On Mon, 6 Jun 2005 14:02:04 -0500 (CDT)
Don Erickson <derick at zeni.net> wrote:

> Okay, here's mysql's table of capacity:
> 
> TINYTEXT:   2^8
> TEXT:	    2^16
> MEDIUMTEXT: 2^24
> LONGTEXT:   2^32
> 
> So, I guess you'd need MEDIUMTEXT to store articles of up to
> 16,777,216 characters, and there'd be no bloat.
> 
> LONGTEXT could go to 4,294,967,296 characters, and still no bloat.
> 
> I belive that TEXT field suppport is fairly new in mysql, or at least
> I haven't known about it for very long.

  So MySQL has a limit on the max size a LONGTEXT can hold?
  Interesting...

 ---------------------------------
   Frank Wiles <frank at wiles.org>
   http://www.wiles.org
 ---------------------------------