PHP mysql_query data size limit?

Question

I am trying to UPDATE a mysql TEXT data-type column with a string contains near 6,000 characters inside (6 kb data-size). Then the column is not updated with that data.

Then when i test this column by updating with test data around 100 characters, it works.

So, is there any limit on mysql query processing?
If so, how can i adjust it?

I'm using XAMPP on MacOSX.

AFAIK, If the limit was reached your data would be truncated - not ignored completely. Take PHP out of the equation and copy/paste the rendered query into mysql. — Mike B
– Mike B, Commented Jun 18, 2012 at 14:34
Have you ensured there are no special characters breaking your query? — Josh
– Josh, Commented Jun 18, 2012 at 14:35
text data type can have up to 65,535 characters. There is probably another problem with your data. Any special characters you are inserting? — juergen d
– juergen d, Commented Jun 18, 2012 at 14:35
Are you doing any error checking after your query? Can you show your code? — Pekka
– Pekka, Commented Jun 18, 2012 at 14:36
Oh, @Josh and other guys, thankssss about reminding special character. I was not checked it and now its ok by using mysql_escape_string. Thanks again :) — 夏期劇場
– 夏期劇場, Commented Jun 18, 2012 at 14:40

Sherlock · Accepted Answer · 2012-06-18 14:37:22Z

4

Try escaping your data properly. Your data would be truncated rather than denied (by default) by MySQL if it wouldn't fit. The max size for TEXT field is 64kb.

If your data contains characters like ' and " your query could fail. Add proper error handling to determine where and why things go wrong and escape your data accordingly.

answered Jun 18, 2012 at 14:37

Sherlock

7,6356 gold badges42 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

夏期劇場 Over a year ago

Oh yes it is escaping problem. Now its ok with mysql_escape_string .. thanks :)

Sherlock Over a year ago

In that case, mark this question answered please. Also, mysql_* is getting deprecated: cz.php.net/mysql_connect

Sherlock Over a year ago

Yes, MySQLI and PDO are replacing mysql_*. The deprecation process has begun, but it's not yet deprecated.

Cazuma Nii Cavalcanti Over a year ago

Actually, as of PHP 4.3.0, mysql_real_escape_string() should be used with MySQL extension instead of mysql_escape_string()

Collectives™ on Stack Overflow

PHP mysql_query data size limit?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related