RE: [PHP] mySQL Data Limits

TEXT has a limit of 65535 characters. BLOB TEXT A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters. See section 6.5.3.1 Silent Column Specification Changes. See section 6.2.3.2 The BLOB and TEXT Types. MEDIUMBLOB MEDIUMTEXT A BLOB or TEXT column with a maximum length of 16777215 (2^24 - 1) characters. See section 6.5.3.1 Silent Column Specification Changes. See section 6.2.3.2 The BLOB and TEXT Types. LONGBLOB LONGTEXT A BLOB or TEXT column with a maximum length of 4294967295 (2^32 - 1) characters. See section 6.5.3.1 Silent Column Specification Changes. Note that because the server/client protocol and MyISAM tables has currently a limit of 16M per communication packet / table row, you can't yet use this the whole range of this type. See section 6.2.3.2 The BLOB and TEXT Types. ---John Holmes... > -----Original Message----- > From: JSheble [mailto:justformailinglists@wizaerd.com] > Sent: Tuesday, April 23, 2002 3:43 PM > To: PHP List > Subject: [PHP] mySQL Data Limits > > I have a database with a TEXT field in it, and I've been using it this way > for over three years... today was the first time an INSERT was truncated > on > this field... It was an unusually large INSERT, and due to the truncation > I'm now has wondering what are the limits (if any) on inserting data into > a > TEXT field via PHP through an HTML form? All the data was submitted > (non-truncated) because an email was composed and sent out based on the > form data, but the data in the database did not make it completely... > > thanx... > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php