php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #11593 varchar(8000) field in MSSQL returns only 4096 chars
Submitted: 2001-06-20 17:22 UTC Modified: 2001-11-14 17:56 UTC
From: cm at icesmedia dot de Assigned:
Status: Closed Package: MSSQL related
PHP Version: 4.0.6 OS: NT4.0
Private report: No CVE-ID: None
View Developer Edit
 [2001-06-20 17:22 UTC] cm at icesmedia dot 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-06-24 09:45 UTC] cm at icesmedia dot de 
still the same on the new version 4.0.6. mssql_fetch_array() delivers only the first 4k. please help.
 [2001-11-14 17:56 UTC] fmk@php.net 
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.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved. 		Last updated: Sat Sep 14 16:01:27 2024 UTC