RE: [PHP-DB] php maximum characters in text field

2007-10-18 Thread VanBuskirk, Patricia
ts.php.net Subject: Re: [PHP-DB] php maximum characters in text field Hi > Does anyone know how to look for a "Curly quote" or "typographer's quotation mark". Do you mean the equivalent of the left and right double quote entities in HTML (or 66's and 99's as we c

Re: [PHP-DB] php maximum characters in text field

2007-10-17 Thread Niel Archer
Hi > Does anyone know how to look for a "Curly quote" or "typographer's quotation > mark". Do you mean the equivalent of the left and right double quote entities in HTML (or 66's and 99's as we called them at school)? -- Niel Archer -- PHP Database Mailing List (http://www.php.net/) To unsub

RE: [PHP-DB] php maximum characters in text field

2007-10-17 Thread VanBuskirk, Patricia
$replace = array("'", "'", '"', '"', '-'); return str_replace($search, $replace, $string); } -Original Message- From: Instruct ICC [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 17, 2007 1

RE: [PHP-DB] php maximum characters in text field

2007-10-17 Thread Instruct ICC
> Does anyone know how to look for a "Curly quote" or "typographer's quotation > mark". They are being submitted on our form under customer description. I > have created a function that replaces a regular straight quotation mark > ($title = str_replace("'", "", $title);), but do not know what t

RE: [PHP-DB] php maximum characters in text field

2007-10-17 Thread VanBuskirk, Patricia
uot;", $title);), but do not know what to put in as the "look for" for the curly mark! -Original Message- From: Instruct ICC [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 3:29 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread Instruct ICC
Do you see those apostrophes in that text? They need to be properly escaped. > Date: Mon, 15 Oct 2007 15:09:52 -0400 > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; php-db@lists.php.net > Subject: RE: [PHP-DB] php maximum characters in text field > >

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread VanBuskirk, Patricia
AIL PROTECTED] Thank you, Stuart Pearce -Original Message- From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 1:48 PM To: VanBuskirk, Patricia; Instruct ICC; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Could it be an '

Re: [PHP-DB] php maximum characters in text field

2007-10-15 Thread OKi98
ined variable" error. -Original Message- From: Instruct ICC [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 1:05 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field I am starting to believe it is NOT the character length that is causing the p

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread Bastien Koert
Could it be an '&' ampersand in the data? Bastien> Date: Mon, 15 Oct 2007 13:29:02 -0400> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]; php-db@lists.php.net> Subject: RE: [PHP-DB] php maximum characters in text field> > It isn't sending to MySql, we u

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread VanBuskirk, Patricia
ssage- From: Instruct ICC [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 1:05 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field > I am starting to believe it is NOT the character length that is causing the > problem. We have received ot

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread Instruct ICC
> I am starting to believe it is NOT the character length that is causing the > problem. We have received other orders with more in it than that, and they > came in ok. I think there may be something in the input that php does not > like. I've been searching for code that will "clean up" input,

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread VanBuskirk, Patricia
up" input, possibly preg_replace? -Original Message- From: Instruct ICC [mailto:[EMAIL PROTECTED] Sent: Monday, October 15, 2007 10:37 AM To: php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field > >varchar maxs out at 255 characters > just for clar

RE: [PHP-DB] php maximum characters in text field

2007-10-15 Thread Instruct ICC
> >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 News to me, so I check the docs. http://

Re: [PHP-DB] php maximum characters in text field

2007-10-15 Thread OKi98
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 i

RE: [PHP-DB] php maximum characters in text field

2007-10-13 Thread Jürgen Wind
>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.co

RE: [PHP-DB] php maximum characters in text field

2007-10-12 Thread Bastien Koert
Yes, that is the HTML and the PHP code to check. What about the php code to go to the db? Bastien> Date: Fri, 12 Oct 2007 11:42:25 -0400> From: [EMAIL PROTECTED]> To: [EMAIL PROTECTED]; php-db@lists.php.net> Subject: RE: [PHP-DB] php maximum characters in text field> > The

RE: [PHP-DB] php maximum characters in text field

2007-10-12 Thread VanBuskirk, Patricia
The field on the form is as such: The confirmation page is: From: Bastien Koert [mailto:[EMAIL PROTECTED] 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

RE: [PHP-DB] php maximum characters in text field

2007-10-12 Thread Bastien Koert
variable” errors wherever the database was supposed to send back info, and no record was created. From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:12 AMTo: VanBuskirk, Patricia; [EMAIL PROTECTED]: RE: [PHP-DB] php maximum characters in text field Unless you

RE: [PHP-DB] php maximum characters in text field

2007-10-12 Thread VanBuskirk, Patricia
"Undefined variable" errors wherever the database was supposed to send back info, and no record was created. From: Bastien Koert [mailto:[EMAIL PROTECTED] Sent: Friday, October 12, 2007 11:12 AM To: VanBuskirk, Patricia; php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in

RE: [PHP-DB] php maximum characters in text field

2007-10-12 Thread Bastien Koert
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: [EMAIL PROTECTED]> To: ph