6 Jun
2005
6 Jun
'05
7:13 p.m.
On Mon, 6 Jun 2005 14:02:04 -0500 (CDT) Don Erickson [email protected] 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 [email protected] http://www.wiles.org ---------------------------------