PHP 4.0 Bug #5237: Error reading LONG fields (ntext) in MSSQL (SQL Server)
| From: | jeff at k-linx dot com | Date: | Tue, 27 Jun 2000 21:07:12 +0000 |
| Subject: | PHP 4.0 Bug #5237: Error reading LONG fields (ntext) in MSSQL (SQL Server) | ||
| Groups: | php.dev | ||
| Request: | Send a blank email to php-dev+get-22408@lists.php.net to get a copy of this message | ||
From: jeff@k-linx.com
Operating system: WinNT
PHP version: 4.0.0 Release
PHP Bug Type: ODBC related
Bug description: Error reading LONG fields (ntext) in MSSQL (SQL Server)
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.