Re: FreeTDS and numeric fields in MSSQL2005 database

I hesitate to chip in here, since I am still learning my way around
FreeTDS, but ... I wonder if it has to do with different locale
settings?

Andy Wakefield
[email protected] 

On Thu, 2010-02-18 at 17:13 +0100, Michal Seliga wrote:

> hi
> 
> I just noticed that numerical values differ when i connect to the same database
> from windows (using microsoft driver) and from linux (using freetds driver)
> 
> i work with them as with text (which means no conversion is done and i use
> exactly what is read from database, i checked qt sources to make sure that this
> is how it works)
> 
> values are mathematically the same, but format is a bit different. for example
> same value is read in windows '.0000' and in linux '0.0000'. and also it seems
> that for colum which is for example numeric(16,4) in windows returned value may
> have less decimal places then 4, while in linux there are always 4
> 
> is there any conversion made by FreeTDS? (or maybe by microsoft driver?) can i
> be sure that i won't get different values when working from different environments?
> 
> so far its not an issue, i am only curios if i can expect problems in future or
> I may forget about it
> 
> btw current cvs version is great, all issues i used to have are gone (ok, there
> is one but foe now i think its problem of qt and not of freetds). congratulations!
> _______________________________________________
> FreeTDS mailing list
> [email protected]
> http://lists.ibiblio.org/mailman/listinfo/freetds