Re: Addslashes limit [SOLVED]
| From: | Cesar Cordovez | Date: | Wed, 17 Dec 2003 15:32:16 +0000 |
| Subject: | Re: Addslashes limit [SOLVED] | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-172885@lists.php.net to get a copy of this message | ||
Hi.
Turns out that addslashes is not guilty of truncating it's result. Marek is right here. Changed the type of the field from BLOB to LONGBLOB and everything works great!
Thanks!
Marek Kilimajer wrote:
Cesar Cordovez wrote:HI! Is it just me or addslahes truncates the result to 65535 chars? Any comments? Or can it be that a blob field in a MySQL database is just 65535 chars, I don't think so... Cesar.BLOB is just 65535 chars. Use MEDIUMBLOB (2^24 bytes) or LONGBLOB (2^32 bytes). Also textarea field in browsers has a limit.