sqlQuery precision issue
Probably FAQ 7.31 Floating point numbers only have about 15 digits of precision. On Saturday, October 8, 2011, Mai Dang @BigPond <mdang2 at bigpond.com.au> wrote:
Hi All, Can you please have a look at precision issue in sqlQuery statement as below example This is not related to the database as this fault is reproducible with different databases.
library(RODBC)
orcl<- odbcConnect("orcl",uid="user_id",pwd="password")
ca_con <- format(sqlQuery(card, paste("select '453458325698925182' as
long_string from dual")), digits=20)
ca_con
LONG_STRING 1 453458325698924992 Mai Dang
_______________________________________________ R-sig-DB mailing list -- R Special Interest Group R-sig-DB at r-project.org https://stat.ethz.ch/mailman/listinfo/r-sig-db
Jim Holtman Data Munger Guru What is the problem that you are trying to solve? [[alternative HTML version deleted]]