RE: [PHP] PROBLEMS WHEN EXTRACING DATA FROM MSSQL DATABASE WITH PHP
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
RE: [PHP] PROBLEMS WHEN EXTRACING DATA FROM MSSQL DATABASE WITH PHP
Larry Brown mailto:[EMAIL PROTECTED] on Monday, December 22, 2003 3:59 PM said: 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 :-) Uhh... he stated in his original email that he's using MSSQL (not MySQL) and that the data is being INSERTed completely and without error. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] PROBLEMS WHEN EXTRACING DATA FROM MSSQL DATABASE WITH PHP
My bad, didn't read far enough... -Original Message- From: Chris W. Parker [mailto:[EMAIL PROTECTED] Sent: Monday, December 22, 2003 7:04 PM To: Larry Brown; Dale Hersh; PHP List Subject: RE: [PHP] PROBLEMS WHEN EXTRACING DATA FROM MSSQL DATABASE WITH PHP Larry Brown mailto:[EMAIL PROTECTED] on Monday, December 22, 2003 3:59 PM said: 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 :-) Uhh... he stated in his original email that he's using MSSQL (not MySQL) and that the data is being INSERTed completely and without error. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php