ID: 38805
Comment by: rockyjl at gmail 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:
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 ???
Previous Comments:
------------------------------------------------------------------------
[2007-08-13 19:22:32] jagwire16 at hotmail dot com
http://us3.php.net/manual/en/function.mssql-query.php#64470 reports how
to make it work and that solution worked for me.
------------------------------------------------------------------------
[2007-02-14 16:16:49] matt at educause dot edu
I too can reproduce this problem ... a critical hurdle for us.
------------------------------------------------------------------------
[2006-12-06 14:50:17] frank at interlevel dot com
Seems I am not alone on this. I have also tried altering the PHP.ini
with no result. IS there an update to this PDO?
------------------------------------------------------------------------
[2006-11-08 14:30:06] mark dot pearson at capita dot co dot uk
I have found the same problem with PHP 5.1.6 running on Windows XP Pro
SP2 and MS SQL Server 2000 (using the pdo_mssql driver).
I also tried to solve it by setting the mssql.textlimit and
mssql.textsize INI options, since that used to cause the same problem in
the mssql extension but it doesn't have any effect on the values
returned by PDO.
------------------------------------------------------------------------
[2006-09-26 16:22:57] ritch at bugsoftware dot co dot uk
I'm also suffering this problem after changing my database connection
type to PDO.
I'm running PHP 5.1.2 on Windows server 2003 with MSSQL 2005.
In the old mssql ext. you had to specificaly tell the configure it in
php.ini to bring back larger text fields:
; Valid range 0 - 2147483647. Default = 4096.
mssql.textlimit = 2147483647
; Valid range 0 - 2147483647. Default = 4096.
mssql.textsize = 2147483647
I have not found the same for the new PDO extension - so I'm assuming
this has some thing to do with the problem. (My text fields are also
truncated to 4096)
Help with this issue would be greatley appreciated.
------------------------------------------------------------------------
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
