[PHP-DB] Truncated fields

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

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 and

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 the