When RMySQL is unable to map a type from MySQL to R, mysqlExecStatement
issues the following warning.
It is possible to overload dbGetQuery to do some post processing of the queries such that the Type is mapped correctly. See, e.g., dp.misc/dbGetQuery for an example.
Warning message:
In mysqlExecStatement(conn, statement, ...) :
RS-DBI driver warning: (unrecognized MySQL field type 7 in column 5 imported as character)
When RMySQL is unable to map a type from MySQL to R,
mysqlExecStatementissues the following warning.
It is possible to overload dbGetQuery to do some post processing of the queries such that the Type is mapped correctly. See, e.g.,
dp.misc/dbGetQueryfor an example.