|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2002-01-22 23:31 UTC] royal at altech dot com dot pl
[2002-04-02 22:04 UTC] pipperl at pchome dot com dot tw
[2002-10-14 22:55 UTC] iliaa@php.net
[2002-10-30 01:00 UTC] php-bugs at lists dot php dot net
[2002-10-30 05:44 UTC] royal at altech dot com dot pl
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Nov 06 18:00:01 2025 UTC |
<? $msid=mssql_connect ($server,$user,$pass); mssql_select_db("database", $msid); $msres=mssql_query("SELECT * FROM TABLE", $msid); $ret=mssql_fetch_row($msres); // or $ret=mssql_fetch_array($msres); // or $ret=mssql_fetch_object($msres); // or $ret=mssql_fetch_field($msres,23); // or $ret=mssql_result ($msres, 0, 23); var_dump($ret); ?> every field is returned correctly except of 'datetime' type fields which instead turns to be string(4) containing " :" or hexadecimally: x20x20x20x3a. I use freetds 0.53 connecting to MSSQL 7.0 server. The 'sqsh' tool works correct. It seems the problem exists in PHP code. It doesn't matter if I use sybase_* or mssql_* functions, the results are the same! configure line (taken from phpinfo()): './configure' '--with-apxs=/usr/local/sbin/apxs' '--with-config-file-path=/usr/local/etc' '--enable-versioning' '--with-system-regex' '--disable-debug' '--enable-track-vars' '--without-gd' '--without-mysql' '--with-gd=/usr/local' '--with-freetype-dir=/usr/local' '--with-jpeg-dir=/usr/local' '--with-png-dir=/usr/local' '--with-zlib' '--with-mcrypt=/usr/local' '--with-mhash=/usr/local' '--with-imap-ssl=/usr/local' '--with-mysql=/usr/local' '--with-sybase=/usr/local' '--with-ldap=/usr/local' '--with-xml' '--with-expat-dir=/usr/local' '--enable-xslt' '--with-xslt-sablot' '--with-expat-dir=/usr/local' '--enable-ftp' '--with-curl=/usr/local' '--with-gettext=/usr/local' '--with-iconv=/usr/local' '--with-pspell=/usr/local' '--with-ming=/usr/local' '--enable-sockets' '--enable-trans-sid' '--with-imap=/usr/local' '--with-iconv=/usr/local' '--prefix=/usr/local' 'i386--freebsd4.4'