php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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 Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: cm at icesmedia dot de
New email:
PHP Version: OS:

 

 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2022 The PHP Group
All rights reserved.
Last updated: Tue May 17 15:03:34 2022 UTC