Bug #11593 Updated: varchar(8000) field in MSSQL returns only 4096 chars

ID: 11593 Updated by: fmk Reported By: cm@icesmedia.de Old Status: Open Status: Closed Bug Type: MSSQL related Operating System: NT4.0 PHP Version: 4.0.6 New Comment: The DB Library used for the MSSQL extension does not support char and varchar columns with more than 256 characters. char and varchar columns was extended from 256 to 8000 in SQL Server 7.0 but the DB library from Microsoft was not updated. If you want to use wide columns use the text type. Further textlimit only affects columns of type text. It has no effect on char or varchar columns. Previous Comments: ------------------------------------------------------------------------ [2001-06-24 09:45:15] cm@icesmedia.de still the same on the new version 4.0.6. mssql_fetch_array() delivers only the first 4k. please help. ------------------------------------------------------------------------ [2001-06-20 17:22:32] cm@icesmedia.de i have a table with varchar(8000) fields. tried to get the content. php delivers only the first 4k. odbc delivers the full range... i've added in the php.ini the setings for mssql.textlimit to 8192 and for mssql.textsize to 8192, too phpinfo() shows me my ini-settings but the content is stille 4k. please help asap. many thanks and best regards christian marnitz ------------------------------------------------------------------------ Edit this bug report at http://bugs.php.net/?id=11593&edit=1