[freetds] Server - Problems with TDS 4.2 COLFMT token

James K. Lowden jklowden at schemamania.org
Sun May 16 14:33:23 EDT 2004

On Sat, 15 May 2004, Steve Kirkendall <skirkendall at dsl-only.net> wrote:
> 3) For "timestamp", the SQL_DATETIME_SUB and INTERVAL_PRECISION columns
>    in sp_datatype_info's result table are null.  So that probably isn't
>    why Crystal Reports is truncating timestamps at 8 characters.  One
>    weird thing: your server reports "timestamp" as being generic binary
>    (type code -2) instead of ODBC timestamp (type code 11).

If you look in the ML archives, you'll find a short thread a few months
ago about timestamp data as it relates to BCP.  IIRC, the only way a
client knows it's got a timestamp column -- as opposed to, say, a generic
binary -- is that the server sets the usertype to 50.  You'll find some
brief mentions of that in Sybase's TDS functional specs, and, less
plainly, in Microsoft's documentation.  


More information about the FreeTDS mailing list