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

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
>