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

2007-10-18 Thread VanBuskirk, Patricia
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 called them at school)? -- Niel Archer -- PHP

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

2007-10-17 Thread VanBuskirk, Patricia
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 Do you see those apostrophes in that text? They need to be properly

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 to put in as

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

2007-10-17 Thread VanBuskirk, Patricia
(', ', '', '', '-'); return str_replace($search, $replace, $string); } -Original Message- From: Instruct ICC [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 17, 2007 1:54 PM To: php-db@lists.php.net Subject: RE: [PHP-DB] php maximum characters in text field Does

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

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

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.

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

2007-10-15 Thread VanBuskirk, Patricia
, 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 clarification, mysql varchar easily

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
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 other orders with more in it than

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

2007-10-15 Thread OKi98
. -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 problem. We have received other

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 Here is the exact text he

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:

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

2007-10-12 Thread Bastien Koert
-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

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 field on the form

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
with 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 text field

[PHP-DB] php maximum characters in text field

2007-10-12 Thread VanBuskirk, Patricia
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

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

2007-10-12 Thread 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