[R-sig-DB] sqlQuery precision issue

jim holtman jho|tm@n @end|ng |rom gm@||@com
Sat Oct 8 19:08:06 CEST 2011


Probably FAQ 7.31

Floating point numbers only have about 15 digits of precision.

On Saturday, October 8, 2011, Mai Dang @BigPond <mdang2 using 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 using 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]]




More information about the R-sig-DB mailing list