[freetds] FreeTDS ODBC Driver handles MONEY type incorretly onSolaris/SPARC

ZIGLIO, Frediano, VF-IT Frediano.Ziglio at vodafone.com
Tue Apr 20 11:33:41 EDT 2004


> 
> Just test the FreeTDS ODBC Driver on the Solaris/SPARC and 
> try to fetch a
> table consists of only one column which is of MONEY type.
> 
> I couldn't get the data; the sql type returned by the FreeTDS 
> ODBC Driver
> was SQL_UNKOWN_TYPE.
> 
>  
> 
> I found out that in odbc_util.c:
> 
>  
> 
> case SYBMONEY4:
> 
>                         return SQL_DOUBLE;
> 
> case SYBMONEYN:
> 
>                         break;
> 
>  
> 
> And the col_type is always SYBMONEYN no matter how I change 
> the attribute of
> the columns: Money, SmallMoney, Money not nullable, 
> smallmoney not nullable.
> 

??? this code is obsolete, fixed some time ago (both 0.62 and 0.63)

freddy77



More information about the FreeTDS mailing list