php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #5237 Error reading LONG fields (ntext) in MSSQL (SQL Server)
Submitted: 2000-06-27 17:07 UTC Modified: 2000-08-18 13:29 UTC
From: jeff at k-linx dot com Assigned:
Status: Closed Package: ODBC related
PHP Version: 4.0.0 Release OS: WinNT
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jeff at k-linx dot com
New email:
PHP Version: OS:

 

 [2000-06-27 17:07 UTC] jeff at k-linx dot com
When you try to retrieve a LONG field or ntext field in 
MSSQL, PHP simply crashes.  

I have found a workaround by issuing a SET TEXTSIZE nnnn
before the select, but this is a MSSQL specific call and 
therefore undermines the whole ODBC concept.

I should be able to use the ODBC functions against ANY ODBC
compliant database and since I have ODBC drivers for MSSQL
and am able to setup a System DSN and access it thru PHP, I
should be able to access the data the same as if it were
MSAccess or Oracle or Sybase etc.

This needs to be fixed.  I can access LONG fields in other
databases without any problem.


Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2000-07-26 01:55 UTC] waldschrott@php.net
Please verify that it?s still happening using the latest version of PHP (release 4.0.1pl2 or CVS).
 [2000-08-18 13:29 UTC] waldschrott@php.net
Closed due to missing user feedback.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Thu May 08 16:01:28 2025 UTC