#38805 [Com]: PDO Truncates Text from SQL Server Text Data Type Field

From: Date: Wed, 18 Jun 2008 12:04:35 +0000
Subject: #38805 [Com]: PDO Truncates Text from SQL Server Text Data Type Field
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-125845@lists.php.net to get a copy of this message 
 ID:               38805
 Comment by:       me at opensol dot com
 Reported By:      gkrajci at arescorporation dot com
 Status:           Assigned
 Bug Type:         PDO related
 Operating System: Windows NT PBMA-WB2 5.2 build 37
 PHP Version:      5.1.6
 Assigned To:      wez
 New Comment:

I can confirm this bug in php 5.2.5

This is a heavy bug, please fix this soon! 

A setting like 
mssql.textlimit = 2147483647
mssql.textsize = 2147483647
would be great!


Previous Comments:
------------------------------------------------------------------------

[2008-03-27 08:25:53] andrew-law at yandex dot ru

It's a pity php developers don't hear their colleagues. This is a
critical bug and it hasn't fixed yet.

------------------------------------------------------------------------

[2008-01-09 15:14:17] rob at tdd dot org dot uk

I have found that it doesn't get truncted with ODBC, however I have
found certain stored procedures don't work with ODBC. My solution is to
create a DAL class which has a factory method to create a PDO connection
based on driver selection. Then during my testing if I find it to work
in one and not in another then I switch the database connection over to
the one that works.

------------------------------------------------------------------------

[2007-11-17 03:21:20] rockyjl at gmail dot com

why can't fix in php 5.2.5 ???? this is very importance for developer
!!!!!

------------------------------------------------------------------------

[2007-11-17 03:15:08] rockyjl at gmail dot com

why can't fix in php 5.2.5 ???? this is very importance for developer
!!!!!

------------------------------------------------------------------------

[2007-09-11 08:36:42] rockyjl at gmail dot com

ini_set('mssql.textlimit', '65536');
ini_set('mssql.textsize', '65536'); 

it is work for php_mssql.dll

but not work for php_pdo_mssql.dll

how can i get more than 4096 byte in TEXT with php_pdo_mssql.dll ???

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/38805

-- 
Edit this bug report at http://bugs.php.net/?id=38805&edit=1

Thread (42 messages)

« previous php.bugs (#125845) next »