Home > Archive > PHP DB > October 2007 > RE: [PHP-DB] php maximum characters in text field
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
RE: [PHP-DB] php maximum characters in text field
|
|
| Bastien Koert 2007-10-12, 7:00 pm |
|
Unless you are using a text field (which holds 64K [mysql]) a normal varchar maxs out at 255 characters
Post is limited by the php.ini file amounts (usually in the megabyte range)..
what is the size of the post?
Bastien> Date: Fri, 12 Oct 2007 10:41:15 -0400> From: pvanbuskirk@otc.fsu.edu> To: php-db@lists.php.net> Subject: [PHP-DB] php maximum characters in text field> > Is there a maximum number of character $_POST will/can return from a> text field. I have an online form that was driving me nuts trying to> troubleshoot, as most orders were coming in fine, but this one would> not. I narrowed down to the length of the "customer description" field> whichhas no limits on the form or in the database. I was told there> was a limit to how much $_POST could return. Can someone advise?> > > > Thanks!> > Trish>
________________________________________
_________________________
Express yourself with free Messenger emoticons. Get them today!
http://www.freemessengeremoticons.ca/?icid=EMENCA122
| |
| VanBuskirk, Patricia 2007-10-12, 7:00 pm |
| The info he was trying to submit was 883 characters, including spaces
(counted in Word). Many times, people have very detailed descriptions
they need to send in. Can you think of a way to work around this
limitation? Also, what happened when he tried to submit is he got an
email back with "Undefined variable" errors wherever the database was
supposed to send back info, and no record was created.
From: Bastien Koert [mailto:bastien_k@hotmail.com]
Sent: Friday, October 12, 2007 11:12 AM
To: VanBuskirk, Patricia; php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field
Unless you are using a text field (which holds 64K [mysql]) a normal
varchar maxs out at 255 characters
Post is limited by the php.ini file amounts (usually in the megabyte
range).
what is the size of the post?
Bastien
> Date: Fri, 12 Oct 2007 10:41:15 -0400
> From: pvanbuskirk@otc.fsu.edu
> To: php-db@lists.php.net
> Subject: [PHP-DB] php maximum characters in text field
>
> Is there a maximum number of character $_POST will/can return from a
> text field. I have an online form that was driving me nuts trying to
> troubleshoot, as most orders were coming in fine, but this one would
> not. I narrowed down to the length of the "customer description" field
> which has no limits on the form or in the database. I was told there
> was a limit to how much $_POST could return. Can someone advise?
>
>
>
> Thanks!
>
> Trish
>
________________________________
Express yourself with free Messenger emoticons. Get them today!
<http://www.freemessengeremoticons.ca/?icid=EMENCA122>
| |
| VanBuskirk, Patricia 2007-10-12, 7:00 pm |
| The field on the form is as such: <TEXTAREA name="Customer_Description"
cols=100 rows=10 tabindex="44"></TEXTAREA>
The confirmation page is: <?php echo ($_POST['Customer_Description']);
?>
From: Bastien Koert [mailto:bastien_k@hotmail.com]
Sent: Friday, October 12, 2007 11:26 AM
To: VanBuskirk, Patricia; php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field
And how is the table / field of interest configured? 833 will obviously
not fit into a 255 varchar field...
Bastien
________________________________
Subject: RE: [PHP-DB] php maximum characters in text field
Date: Fri, 12 Oct 2007 11:24:14 -0400
From: pvanbuskirk@otc.fsu.edu
To: bastien_k@hotmail.com; php-db@lists.php.net
The info he was trying to submit was 883 characters, including spaces
(counted in Word). Many times, people have very detailed descriptions
they need to send in. Can you think of a way to work around this
limitation? Also, what happened when he tried to submit is he got an
email back with "Undefined variable" errors wherever the database was
supposed to send back info, and no record was created.
From: Bastien Koert [mailto:bastien_k@hotmail.com]
Sent: Friday, October 12, 2007 11:12 AM
To: VanBuskirk, Patricia; php-db@lists.php.net
Subject: RE: [PHP-DB] php maximum characters in text field
Unless you are using a text field (which holds 64K [mysql]) a normal
varchar maxs out at 255 characters
Post is limited by the php.ini file amounts (usually in the megabyte
range).
what is the size of the post?
Bastien
> Date: Fri, 12 Oct 2007 10:41:15 -0400
> From: pvanbuskirk@otc.fsu.edu
> To: php-db@lists.php.net
> Subject: [PHP-DB] php maximum characters in text field
>
> Is there a maximum number of character $_POST will/can return from a
> text field. I have an online form that was driving me nuts trying to
> troubleshoot, as most orders were coming in fine, but this one would
> not. I narrowed down to the length of the "customer description" field
> which has no limits on the form or in the database. I was told there
> was a limit to how much $_POST could return. Can someone advise?
>
>
>
> Thanks!
>
> Trish
>
________________________________
Express yourself with free Messenger emoticons. Get them today!
<http://www.freemessengeremoticons.ca/?icid=EMENCA122>
________________________________
R U Ready for Windows Live Messenger Beta 8.5? Try it today!
<http://entertainment.sympatico.msn....wsLiveMessenger>
| |
| Jürgen Wind 2007-10-13, 6:59 pm |
|
>varchar maxs out at 255 characters
just for clarification, mysql varchar easily can hold more than 255
characters
(I remember it was the case in ancient 3.x times)
only if one wants to store newlines he must use type "text"
just my 2 cent
--
View this message in context: http://www.nabble.com/php-maximum-c....html#a13191426
Sent from the Php - Database mailing list archive at Nabble.com.
| |
|
| VanBuskirk, Patricia napsal(a):
> The info he was trying to submit was 883 characters, including spaces
> (counted in Word). Many times, people have very detailed descriptions
> they need to send in. Can you think of a way to work around this
> limitation? Also, what happened when he tried to submit is he got an
> email back with "Undefined variable" errors wherever the database was
> supposed to send back info, and no record was created.
>
>
I guess you are using get method of http request which is limited by
"maximum URL Length" (2083 chars in IE). Force the browser to use post
by <form method="post">.
OKi98
|
|
|
|
|