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:[EMAIL PROTECTED]]
> 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
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php