Jump to content


Photo

pushing it to the limit


  • Please log in to reply
5 replies to this topic

#1 michaellunsford

michaellunsford
  • Members
  • PipPipPip
  • Advanced Member
  • 1,023 posts
  • LocationLouisiana, USA

Posted 24 August 2006 - 05:23 PM

I have a client attempting to post HTML code to a database. In this case, it just happens to be longer than 65,535. The database field (mysql TEXT type field) is recording exactly 65,535 characters of the content. Soo... either there is a $_POST limit I need to stay under, or a database limit.

If it's a POST limit, what is the maximum length of POST? Is it 65,535 per variable, or for the whole array?

#2 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 24 August 2006 - 05:49 PM

AFAIK there is not limit to $_POST

It most probably to do with the Text field type, prehaps use MEDIUMTEXT

#3 onlyican

onlyican
  • Members
  • PipPipPip
  • Advanced Member
  • 921 posts
  • LocationHants - UK

Posted 24 August 2006 - 05:51 PM

<input type='text' there is a limit, I am not sure of the size but there is a limit
Tell me the problem, I will try tell you the solution

#4 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 24 August 2006 - 06:13 PM

I dont thnks he using a text field. As no one will write HTML all in one line! ButI I expect its a textarea, however michaellunsford is about the TEXT data type in MySQL.

#5 michaellunsford

michaellunsford
  • Members
  • PipPipPip
  • Advanced Member
  • 1,023 posts
  • LocationLouisiana, USA

Posted 24 August 2006 - 06:20 PM

I'm using a rich text editor that emulates a <textarea> field. I'll keep the mysql limit in mind -- but for now, I have solved the pressing issue at hand. I ran the html through dreamweaver's "clean up html" command. Presto 65,535 is now 8,923. (there were oodles of nested an redundant tags in there)

Thanks for the help!

#6 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 24 August 2006 - 06:22 PM

My lord! What a reduction! I love dreamweavers clean up html tool!




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users