Re: [R] dbGetQuery() returns wrong value

2018-07-31 Thread Enrico Schumann
Quoting Christofer Bogaso : The data type is defined as bigint Your query does not specify a number, but a string (you single-quote the digits). Databases may do type conversion; for instance, see the MySQL manual: https://dev.mysql.com/doc/refman/8.0/en/type-conversion.html Since you se

Re: [R] dbGetQuery() returns wrong value

2018-07-30 Thread Jeff Newmiller
If you have not read [1] already, you should. As to how JDBC handles this issue I don't know, but such a package-specific conversation belongs on r-sig-db. [1] http://www.win-vector.com/blog/2015/06/r-in-a-64-bit-world/ On July 30, 2018 6:06:04 AM PDT, Christofer Bogaso wrote: >The data type i

Re: [R] dbGetQuery() returns wrong value

2018-07-30 Thread Christofer Bogaso
The data type is defined as bigint On Mon, Jul 30, 2018 at 4:45 PM Eric Berger wrote: > The ID matches in the first 16 characters. > How is your table declared? > > > On Mon, Jul 30, 2018 at 2:00 PM, Christofer Bogaso < > bogaso.christo...@gmail.com> wrote: > >> Session Information for abov

Re: [R] dbGetQuery() returns wrong value

2018-07-30 Thread Eric Berger
The ID matches in the first 16 characters. How is your table declared? On Mon, Jul 30, 2018 at 2:00 PM, Christofer Bogaso < bogaso.christo...@gmail.com> wrote: > Session Information for above error: > > > sessionInfo() > R version 3.5.0 (2018-04-23) > Platform: x86_64-w64-mingw32/x64 (64-bi

Re: [R] dbGetQuery() returns wrong value

2018-07-30 Thread Christofer Bogaso
Session Information for above error: > sessionInfo() R version 3.5.0 (2018-04-23) Platform: x86_64-w64-mingw32/x64 (64-bit) Running under: Windows 10 x64 (build 16299) Matrix products: default locale: [1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252LC_MONETARY=E