Skip to Content.
Sympa Menu

freetds - Re: [freetds] FreeTDS and numeric fields in MSSQL2005 database

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Andrew H. Wakefield" <a_wake AT earthlink.net>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] FreeTDS and numeric fields in MSSQL2005 database
  • Date: Thu, 18 Feb 2010 14:36:39 -0500

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




Archive powered by MHonArc 2.6.24.

Top of Page