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

So the official stance it that PDO::DBLIB is dead?

I tried ODBC, but unixODBC + PDO ODBC has more issues than just the
PDO driver. I tried the ODBC driver and got binding errors after
recoding around the (Cannot compare TEXT to VARCHAR) by using casts, I
then get segfaults on AMD64.

I already submitted a simple patch to move the cached results to an on
demand fetch. Somebody please review and get back to me on any
concerns.

On Tue, Feb 16, 2010 at 8:57 AM, Wez Furlong <[email protected]> wrote:
> 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
>>
>
>