php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #68228 MSSQL: column has unknown data type 98
Submitted: 2014-10-14 14:17 UTC Modified: 2016-10-15 23:19 UTC
Votes:15
Avg. Score:4.2 ± 0.9
Reproduced:12 of 13 (92.3%)
Same Version:7 (58.3%)
Same OS:2 (16.7%)
From: cweiske@php.net Assigned:
Status: Wont fix Package: MSSQL related
PHP Version: 5.6.1 OS:
Private report: No CVE-ID: None
View Developer Edit
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: cweiske@php.net
New email:
PHP Version: OS:

 

 [2014-10-14 14:17 UTC] 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2014-10-14 14:18 UTC] cweiske@php.net
-Summary: unknown data type 98 +Summary: MSSQL: column has unknown data type 98
 [2016-10-15 23:19 UTC] kalle@php.net
-Status: Open +Status: Wont fix
 [2016-10-15 23:19 UTC] kalle@php.net 
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.
 
PHP Copyright © 2001-2026 The PHP Group
All rights reserved. 		Last updated: Wed Oct 07 11:00:02 2026 UTC