Re: [PHP-DB] Truncated fields
You may need to set mssql.textlimit to a value greater than the default of 4096 characters. -- bob On Wed, 21 Jan 2004, Michael Lewis wrote: > John, > > I'm getting much more than 255 characters. The field is not varchar but a > text field. I've looked into FREETDS as the most likely source of the > problem but haven't found anything yet. > > Michael > > > Michael Lewis wrote: > > > > > I'm having a problem with retrieving field data from SQL SERVER 2000 and > am > > > not sure where the problem lies. I have a variable length field (from > 100 - > > > 1 characters). When I retrieve the field using a select statement, > then > > > into a PHP variable such as $text=$r['body_text'], then the field seems > to > > > be truncated after a good bit of it has been returned (at least 1000 > > > characters). I am using PHP 4.3.4 and FREETDS 0.62 on a Red Hat 9.0 > system > > > to access SQL Server. The question is, is there a returned field size > > > maximum defaulting or defined in SQL Server, PHP, or FREETDS and/or has > > > anyone else had this problem? > > > > Not sure where the problem is exactly (I think it's FREETDS), but you > > can only use 255 characters in a variable character column. Newer > > versions of FREETDS may solve this, otherwise change your column type. > > > > -- > > ---John Holmes...> > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Truncated fields
John, I'm getting much more than 255 characters. The field is not varchar but a text field. I've looked into FREETDS as the most likely source of the problem but haven't found anything yet. Michael > Michael Lewis wrote: > > > I'm having a problem with retrieving field data from SQL SERVER 2000 and am > > not sure where the problem lies. I have a variable length field (from 100 - > > 1 characters). When I retrieve the field using a select statement, then > > into a PHP variable such as $text=$r['body_text'], then the field seems to > > be truncated after a good bit of it has been returned (at least 1000 > > characters). I am using PHP 4.3.4 and FREETDS 0.62 on a Red Hat 9.0 system > > to access SQL Server. The question is, is there a returned field size > > maximum defaulting or defined in SQL Server, PHP, or FREETDS and/or has > > anyone else had this problem? > > Not sure where the problem is exactly (I think it's FREETDS), but you > can only use 255 characters in a variable character column. Newer > versions of FREETDS may solve this, otherwise change your column type. > > -- > ---John Holmes...> -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Truncated fields
Michael Lewis wrote: I'm having a problem with retrieving field data from SQL SERVER 2000 and am not sure where the problem lies. I have a variable length field (from 100 - 1 characters). When I retrieve the field using a select statement, then into a PHP variable such as $text=$r['body_text'], then the field seems to be truncated after a good bit of it has been returned (at least 1000 characters). I am using PHP 4.3.4 and FREETDS 0.62 on a Red Hat 9.0 system to access SQL Server. The question is, is there a returned field size maximum defaulting or defined in SQL Server, PHP, or FREETDS and/or has anyone else had this problem? Not sure where the problem is exactly (I think it's FREETDS), but you can only use 255 characters in a variable character column. Newer versions of FREETDS may solve this, otherwise change your column type. -- ---John Holmes... Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/ php|architect: The Magazine for PHP Professionals – www.phparch.com -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Truncated fields
I'm having a problem with retrieving field data from SQL SERVER 2000 and am not sure where the problem lies. I have a variable length field (from 100 - 1 characters). When I retrieve the field using a select statement, then into a PHP variable such as $text=$r['body_text'], then the field seems to be truncated after a good bit of it has been returned (at least 1000 characters). I am using PHP 4.3.4 and FREETDS 0.62 on a Red Hat 9.0 system to access SQL Server. The question is, is there a returned field size maximum defaulting or defined in SQL Server, PHP, or FREETDS and/or has anyone else had this problem? Thanks. Michael -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php