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
 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved.
Last updated: Thu May 02 13:01:30 2024 UTC