FreeTDS Development Group

["Andrew H. Wakefield" <a_wake AT earthlink.net>]

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
a_wake AT earthlink.net 

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
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds