So I can retrieve it in 4k pieces? That's cool. Thanks!
<>< Ryan

-----Original Message-----
From: Frank M. Kromann [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 15, 2002 4:37 PM
To: Ryan Jameson (USA)
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Text Field in SQL Server


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

Reply via email to