You can actually control this on the fly. odbc_binmode($iRecordSet, 2); odbc_longreadlen($iRecordSet, 4096);
$str = ""; while ($temp = odbc_result($iRecordSet, "COLUMN_NAME")) $str .= $temp; This will set the block size to 4k and when you fetch data until the entire column has ben fetched. - Frank > BTW: > > 0 wasn't the right answer, but I get by with 100000. :-) > > -----Original Message----- > From: Ryan Jameson (USA) > Sent: Wednesday, May 15, 2002 4:27 PM > To: [EMAIL PROTECTED] > Subject: RE: [PHP-DB] Text Field in SQL Server > > > I got it: > > In php.ini there is a setting for ODBC called "odbc.defaultlrl", if you change it to >0 it will hand over everything. > > <>< Ryan > > -----Original Message----- > From: Ryan Jameson (USA) > Sent: Wednesday, May 15, 2002 4:17 PM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Text Field in SQL Server > > > When I make a field of Text type (MS SQL Server) and attempt to retrieve it from the >database using PHP ODBC I don't get the whole thing. Anyone have any ideas? > > Thanks. > <>< Ryan > > -- > 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 > > > -- > 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