{"action":"created","issue":{"url":"https://api.github.com/repos/rstats-db/RMySQL/issues/77","repository_url":"https://api.github.com/repos/rstats-db/RMySQL","labels_url":"https://api.github.com/repos/rstats-db/RMySQL/issues/77/labels{/name}","comments_url":"https://api.github.com/repos/rstats-db/RMySQL/issues/77/comments","events_url":"https://api.github.com/repos/rstats-db/RMySQL/issues/77/events","html_url":"https://github.com/rstats-db/RMySQL/issues/77","id":93335659,"number":77,"title":"No way to fetch large integers","user":{"login":"sambrightman","id":536652,"avatar_url":"https://avatars.githubusercontent.com/u/536652?v=3","gravatar_id":"","url":"https://api.github.com/users/sambrightman","html_url":"https://github.com/sambrightman","followers_url":"https://api.github.com/users/sambrightman/followers","following_url":"https://api.github.com/users/sambrightman/following{/other_user}","gists_url":"https://api.github.com/users/sambrightman/gists{/gist_id}","starred_url":"https://api.github.com/users/sambrightman/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sambrightman/subscriptions","organizations_url":"https://api.github.com/users/sambrightman/orgs","repos_url":"https://api.github.com/users/sambrightman/repos","events_url":"https://api.github.com/users/sambrightman/events{/privacy}","received_events_url":"https://api.github.com/users/sambrightman/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/rstats-db/RMySQL/labels/branch:master","name":"branch:master","color":"207de5"}],"state":"open","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/rstats-db/RMySQL/milestones/1","html_url":"https://github.com/rstats-db/RMySQL/milestones/1.0","labels_url":"https://api.github.com/repos/rstats-db/RMySQL/milestones/1/labels","id":1405460,"number":1,"title":"1.0","description":"Next release","creator":{"login":"krlmlr","id":1741643,"avatar_url":"https://avatars.githubusercontent.com/u/1741643?v=3","gravatar_id":"","url":"https://api.github.com/users/krlmlr","html_url":"https://github.com/krlmlr","followers_url":"https://api.github.com/users/krlmlr/followers","following_url":"https://api.github.com/users/krlmlr/following{/other_user}","gists_url":"https://api.github.com/users/krlmlr/gists{/gist_id}","starred_url":"https://api.github.com/users/krlmlr/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/krlmlr/subscriptions","organizations_url":"https://api.github.com/users/krlmlr/orgs","repos_url":"https://api.github.com/users/krlmlr/repos","events_url":"https://api.github.com/users/krlmlr/events{/privacy}","received_events_url":"https://api.github.com/users/krlmlr/received_events","type":"User","site_admin":false},"open_issues":22,"closed_issues":7,"state":"open","created_at":"2015-11-10T21:45:35Z","updated_at":"2016-03-29T17:07:53Z","due_on":null,"closed_at":null},"comments":8,"created_at":"2015-07-06T17:46:02Z","updated_at":"2016-04-02T22:15:46Z","closed_at":null,"body":"As far as I can tell it's not possible to fetch e.g. bigint(20) columns without losing data. Is it possible for RMySQL to provide an option to do the least worst thing and internally switch to doubles for large integer columns? I also int64 and bit64 packages that could be used?"},"comment":{"url":"https://api.github.com/repos/rstats-db/RMySQL/issues/comments/204811253","html_url":"https://github.com/rstats-db/RMySQL/issues/77#issuecomment-204811253","issue_url":"https://api.github.com/repos/rstats-db/RMySQL/issues/77","id":204811253,"user":{"login":"hans-ekbrand","id":551014,"avatar_url":"https://avatars.githubusercontent.com/u/551014?v=3","gravatar_id":"","url":"https://api.github.com/users/hans-ekbrand","html_url":"https://github.com/hans-ekbrand","followers_url":"https://api.github.com/users/hans-ekbrand/followers","following_url":"https://api.github.com/users/hans-ekbrand/following{/other_user}","gists_url":"https://api.github.com/users/hans-ekbrand/gists{/gist_id}","starred_url":"https://api.github.com/users/hans-ekbrand/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/hans-ekbrand/subscriptions","organizations_url":"https://api.github.com/users/hans-ekbrand/orgs","repos_url":"https://api.github.com/users/hans-ekbrand/repos","events_url":"https://api.github.com/users/hans-ekbrand/events{/privacy}","received_events_url":"https://api.github.com/users/hans-ekbrand/received_events","type":"User","site_admin":false},"created_at":"2016-04-02T22:15:46Z","updated_at":"2016-04-02T22:15:46Z","body":"This is a PITA when storing twitter ids in mysql and then retrieving them with RMySQL.\r\n\r\nUnexpectedly, RMySQL mangles data and returns `numeric` even when the column definition is `varchar(20)`, if only the contents is all numbers. I consider this behaviour a bug. I had to resort to using `system()`. e.g.\r\n\r\n`system(command=\"mysql --skip-column-names --batch  -e \\\"select id from tweets\\\"\", intern=TRUE)`\r\n\r\nWhich is exactly what you want to avoid and the reason to use RMySQL."}}