freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

FLOAT and INT in MSSQL

From: Ady Wicaksono <ady AT ebdesk.com>
To: "TDS Development Group" <freetds AT franklin.oit.unc.edu>
Subject: FLOAT and INT in MSSQL
Date: Wed, 12 Dec 2001 11:09:10 +0700

Anybody know how to fetch data from MS-SQL with FLOAT and INT data type ?

I use this one but always wrong

const void *tdsvalue;

///.......... another code

case SYBFLTN :
char *dest = (char *)malloc(256);
sprintf(dest,"%f",*(TDS_REAL *)tdsvalue);
printf("==> %s\n",dest);
break;

it's ok for CHAR,VARCHAR data type in Microsoft SQL Server

FLOAT and INT in MSSQL, Ady Wicaksono, 12/11/2001