FAQ
I am a perl and DBI novice, so pease forgive the possible stupid question.

I am running SQL server and have float column ( real(8) ) defined. The
problem is the rounding between a select statement in the query analyzer and
DBI. A user enters a value like 0.166, when doing a select in Query
Analyzer, they see 0.166. Of course, in DBI they see 0.16599999. They enter
0.002646 and see -2.6459999E-3, etc. Is there an easy way to get
perl's/DBI's display format/precision to match SQL Query Analyzer? Note,
changing the DB Schema is NOT feasible.

Thanks,
Tom Hornyak

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
groupdbi-users @
categoriesperl
postedApr 15, '05 at 9:42p
activeApr 15, '05 at 9:42p
posts1
users1
websitedbi.perl.org

1 user in discussion

Hornyak Thomas: 1 post

People

Translate

site design / logo © 2022 Grokbase