The problem is probably in either your PHP or HTML, not MySQL. It is common to store mutliple words separated by a whitespace in varchar and text fields.
-----Original Message----- From: Anna Noel Leavitt [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 8:40 AM To: [EMAIL PROTECTED] Subject: Re: MySQL Truncated returns > Hello all- > I am using MySql, php and forms in HTML to update information. When I select results from column type VARCHAR, if the information stored > in the column has a space in it (for example, Tampa Bay), it will only > return Tampa (I have the length set at 30 so it is not a length issue). > I tried changing the column type to text to no avail. I > searched the documentation and couldn't figure it out. Can someone > provide some insight for me? > Thanks- > Anna --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php