Truncated fields

From: Date: Thu, 22 Jan 2004 02:55:40 +0000
Subject: Truncated fields
Groups: php.db 
Request: Send a blank email to php-db+get-32575@lists.php.net to get a copy of this message
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 - 10000 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

« previous php.db (#32575) next »