Bug #68228 [Opn->Wfx]: MSSQL: column has unknown data type 98
| From: | kalle@php.net | Date: | Sat, 15 Oct 2016 23:19:16 +0000 |
| Subject: | Bug #68228 [Opn->Wfx]: MSSQL: column has unknown data type 98 | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-204816@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=68228&edit=1
ID: 68228
Updated by: kalle@php.net
Reported by: cweiske@php.net
Summary: MSSQL: column has unknown data type 98
-Status: Open
+Status: Wont fix
Type: Bug
Package: MSSQL related
PHP Version: 5.6.1
Block user comment: N
Private report: N
New Comment:
With MSSQL being removed from PHP as of PHP7.0, and ext/mssql not having a maintainer, I'm
gonna close this report as a Won't fix, until maybe one day it will find a new maintainer.
Alternatively you can use sqlsrv from Microsoft if you are on Windows, or pdo_dblib if you are on
Unix.
Previous Comments:
------------------------------------------------------------------------
[2014-10-14 14:17:33] cweiske@php.net
Description:
------------
Connecting to a MSSQL server and selecting the server property "ProductLevel" results in
PHP giving a warning:
> Warning: mssql_query(): column 1 has unknown data type (98)
According to MSDN[1] it has a "Base data type: nvarchar(128)".
The same warning happens with server property "Edition".
Happens on an MSSQL server ProductVersion "11.0.3128.0", Edition "Standard Edition
(64-bit)", ProductLevel "SP1".
[1] http://msdn.microsoft.com/en-us/library/ms174396.aspx
Test script:
---------------
test.php:
$link = mssql_connect($host, $user, $pass);
mssql_query("SELECT SERVERPROPERTY('ProductLevel')", $link);
/etc/freetds/freetds.conf:
[global]
tds version = 8.0
client charset = UTF-8
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=68228&edit=1