RE: [PHP-DB] Text Field in SQL Server
| From: | USA) | Date: | Wed, 15 May 2002 22:46:48 +0000 |
| Subject: | RE: [PHP-DB] Text Field in SQL Server | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-19204@lists.php.net to get a copy of this message | ||
So I can retrieve it in 4k pieces? That's cool. Thanks!
<>< Ryan
-----Original Message-----
From: Frank M. Kromann [mailto:frank@frontbase.com]
Sent: Wednesday, May 15, 2002 4:37 PM
To: Ryan Jameson (USA)
Cc: php-db@lists.php.net
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: php-db@lists.php.net
> 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: php-db@lists.php.net
> 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
>
>