freetds AT lists.ibiblio.org
Subject: FreeTDS Development Group
List archive
[freetds] FreeTDS and numeric fields in MSSQL2005 database
- From: Michal Seliga <michal.seliga AT visicom.sk>
- To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
- Subject: [freetds] FreeTDS and numeric fields in MSSQL2005 database
- Date: Thu, 18 Feb 2010 17:13:35 +0100
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] FreeTDS and numeric fields in MSSQL2005 database,
Michal Seliga, 02/18/2010
- Re: [freetds] FreeTDS and numeric fields in MSSQL2005 database, Andrew H. Wakefield, 02/18/2010
- <Possible follow-up(s)>
-
Re: [freetds] FreeTDS and numeric fields in MSSQL2005 database,
Thomas Stover, 02/18/2010
-
Re: [freetds] FreeTDS and numeric fields in MSSQL2005 database,
James K. Lowden, 02/18/2010
-
Re: [freetds] FreeTDS and numeric fields in MSSQL2005 database,
Frediano Ziglio, 02/19/2010
- Re: [freetds] FreeTDS and numeric fields in MSSQL2005 database, Michal Seliga, 02/19/2010
-
Re: [freetds] FreeTDS and numeric fields in MSSQL2005 database,
Frediano Ziglio, 02/19/2010
-
Re: [freetds] FreeTDS and numeric fields in MSSQL2005 database,
James K. Lowden, 02/18/2010
Archive powered by MHonArc 2.6.24.