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
