Re: [PHP-DB] Truncated fields

2004-01-21 Thread Robert Twitty
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 t

Re: [PHP-DB] Truncated fields

2004-01-21 Thread Michael Lewis
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

Re: [PHP-DB] Truncated fields

2004-01-21 Thread John W. Holmes
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']