[R-sig-DB] sqlQuery precision issue

[Mai Dang @BigPond]

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