This is a FreeTDS/ODBC driver issue. Still looking into it but isql also returns the truncated value.
Thanks Martin, Peter! -----Original Message----- From: Peter Rabbitson [mailto:[email protected]] Sent: Monday, December 12, 2011 2:28 AM To: DBIx::Class user and developer list Subject: Re: [Dbix-class] data precision question Martin J. Evans wrote: > On 09/12/11 17:44, Alan Humphrey wrote: >> Hi all – >> >> I’ve got a MSSQL database being accessed through ODBC. Several of the >> columns in the database use a datatype of ‘money’. When I query the >> database directly those fields come back with 4 digits of precision. >> >> My problem: by the time the data gets back to me via the resultset >> the column data has been rounded to 2 digits of precision. >> >> This problem persists whether or not I specify a data type in the >> Result definition. >> >> Any thoughts? Would changing the data type in the MSSQL column >> definition help? >> See what are the raw values that get into dbic $rs->cursor->next If this is the correct non-rounded value - show your Result definition, and the code you use + DBIC_TRACE that results in rounded values. _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected] _______________________________________________ List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class IRC: irc.perl.org#dbix-class SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/ Searchable Archive: http://www.grokbase.com/group/[email protected]
