ID: 11593
Updated by: fmk
Reported By: [EMAIL PROTECTED]
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] [EMAIL PROTECTED]

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] [EMAIL PROTECTED]

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


-- 
PHP Development Mailing List <http://www.php.net/>
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to