#33000 [Opn->Fbk]: unknown data type
ID: 33000
Updated by: sniper@php.net
Reported By: thomas at pipelineinteractive dot com
-Status: Open
+Status: Feedback
Bug Type: MSSQL related
Operating System: RedHat 9
PHP Version: 5.0.3
New Comment:
Please try using this CVS snapshot:
http://snaps.php.net/php5-latest.tar.gz
For Windows:
http://snaps.php.net/win32/php5-win32-latest.zip
Previous Comments:
------------------------------------------------------------------------
[2005-05-10 15:29:54] thomas at pipelineinteractive dot com
Description:
------------
Unknown Data Type in Column X returned for Uniqueidentifier Data
Types.
RedHat 9
Apache
FreeTDS 0.63
IconV 1.9.1
FreeTDS Configure:
./configure --prefix=/usr/local/freetds --with-tdsver=8.0
--enable-msdblib --enable-dbmfix --with-gnu-ld --with-iconv=/usr/local
--enable-sybase-compat --enable-extra-checks
PHP Configure:
./configure --with-iconv=/usr/local
--with-apxs2=/usr/local/apache2/bin/apxs --enable-versioning
--with-mssql=/usr/local/freetds --enable-libxml --enable-soap
--with-ftp --enable-sockets --enable-track-vars --enable-versioning
--enable-msdblib
Reproduce code:
---------------
$con = mssql_connect('<IP>', '<user>', '<pass>') or
die(mssql_get_last_message());
mssql_select_db ("<DB>", $con);
$sql= "SELECT TOP 1 * FROM <TABLE>";
$rs= mssql_query ($sql, $con);
echo "The field number one is: ";
echo mssql_result ($rs, 0, 0);
mssql_close ($con);
Expected result:
----------------
The field number one is: <Followed by a Uniqueidentifier>
Actual result:
--------------
Warning: mssql_query() [function.mssql-query]: column 1 has unknown
data type (36) in query.php on line 7
Warning: mssql_query() [function.mssql-query]: column 2 has unknown
data type (36) in query.php on line 7
Warning: mssql_query() [function.mssql-query]: column 15 has unknown
data type (36) in query.php on line 7
The field number one is:
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=33000&edit=1
Thread (2 messages)