[freetds] FreeTDS and numeric fields in MSSQL2005 database
Andrew H. Wakefield
a_wake at earthlink.net
Thu Feb 18 14:36:39 EST 2010
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
More information about the FreeTDS
mailing list