Is your field too small? MySQL doesn't complain when you give it a string longer than it can accept based on the field's size. It just cuts off what doesn't fit :-)
-----Original Message----- From: Dale Hersh [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 6:50 PM To: [EMAIL PROTECTED] Subject: [PHP] PROBLEMS WHEN EXTRACING DATA FROM MSSQL DATABASE WITH PHP I am having a really unusual problem. In my database, I currently have string such as: "I went to the store and bought some food. I then decided to go to the movies and I saw Bad Boy II." When I extract the data out of the database, the data always seems to get cutoff. In other words, I will only get the follow: "I went to the store and bought some food. I then decided to go to the movies and" Is there some type of variable I need to set in the php.in that control how long of a string you can have. It only seems to happen when I am storing long strings in my database. I am using a mssql database. I don't think it is a database issue because I am able to update the database just fine. When I check the database it contains all of the text. When I try to extract the data using php, everything seems to get cut off. Any ideas? Thanks, Dale -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
