Re: [PDO] Re: PDO Truncates Text from SQL Server Text Data Type Field

This may not be the answer you are looking for, but I strongly  
recommend using PDO::ODBC and the FreeTDS ODBC driver instead.

--Wez.

On Feb 14, 2010, at 12:49 PM, Stanley Sufficool wrote:

> I didn't have a problem with text truncation.
>
> The problem I encountered is an issue/bug in PDO::DBLIB at the PDO
> driver level that reads all results into memory before returning it to
> the client. This behavior is unique to mssql_* and PDO::DBLIB, other
> drivers return the data as it is requested by the client. You can test
> it by attempting to read more than 128MB of tabular data from the
> server. If it exceeds the max_mem_per_session PHP.INI setting, the
> script will puke.
>
> To my knowledge, this is not yet fixed as I have not seen a patch get
> committed through this list yet.
>
> Unfortunately, it seems the whole PDO extension is on hold while they
> work out the next revision of PDO. I feel that PDO should clear the
> bug list before it takes on another version.
>
> I would be more than happy to help, but I have yet to gain any patch
> karma yet in order to get CVS access. I have a patch waiting for
> approval.
>
> Just my 2 cents.
>
> On Fri, Feb 12, 2010 at 1:09 AM, Philipp Hellmich
> <[email protected]> wrote:
>> Hi,
>>
>> I manged to get pdo_dblib working with file from cvs...
>>
>> You might want to check this:
>> http://bugs.php.net/bug.php?id=38805
>>
>> Best regards, Philipp
>>
>
> -- 
> PDO Working Group Mailing List (http://pdo.php.net)
> To unsubscribe, visit: http://www.php.net/unsub.php
>