[Dbix-class] data precision question
Peter Rabbitson
rabbit+dbic at rabbit.us
Mon Dec 12 10:28:22 GMT 2011
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.
More information about the DBIx-Class
mailing list