freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

[freetds] possible bug in 0.62rc2 with field type 'datetime' on MSSQL7

From: Andreas Schlögl <andreas.schloegl AT aon.at>
To: freetds AT lists.ibiblio.org
Subject: [freetds] possible bug in 0.62rc2 with field type 'datetime' on MSSQL7
Date: Tue, 6 Jan 2004 11:49:06 +0100

I'm using odbc related PHP commands over unixODBC against a MSSQL7.0 server.
Genarally it works fine, but last night I found that this specific 2
situations seems to fail:
odbc_filed_type() will report
1.)
a field of type 'timestamp' will result in type 'binary' using
odbc_field_type() call from PHP
2.)
a field of type 'datetime' will result in type 'timestamp' using
odbc_field_type() call from PHP

I have not tested all available types, but these are fine:
INTEGER
SMALLINT
TINYINT
VARCHAR

--
Andreas

[freetds] possible bug in 0.62rc2 with field type 'datetime' on MSSQL7, Andreas Schlögl, 01/06/2004
- Re: [freetds] possible bug in 0.62rc2 with field type 'datetime' on MSSQL7, Frediano Ziglio, 01/06/2004