Using RMysql's dbGetQuery in R, how do i coerce string data type on the result set?

Question

RMysql's dbGetQuery converts BigInt to numeric types. This alters some of the values. How can I read the BigInt fields as strings instead of numeric?

Answer 1

One way would be to cast on the SQL side of things:

select cast(foo as char), bar from someTable;

You may have to look up the exact MySQL casting syntax for details.

[ By the way, there is no tag [rstats] here. ]