Re: MySQL Question

On Mon, 6 Jun 2005 14:02:04 -0500 (CDT) Don Erickson derick@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@wiles.org http://www.wiles.org ---------------------------------