Support for MySQL 5.7 JSON

[krlmlr]

Issue by vchav73
Thursday Mar 23, 2017 at 19:15 GMT
Originally opened as r-dbi/RMySQL#189

---

I get the following when attempting to use a MySQL 5.7 database which uses MySQL's new JSON data type. Would be nice if JSON columns were automatically converted to R objects. It has to be done manually for now.

In addition: Warning message:
In .local(conn, statement, ...) :
  unrecognized MySQL field type 245 in column 1 imported as character

[krlmlr]

@vchav73: Can you please double-check what happens with RMariaDB (and post a reproducible example)? I'm not convinced we should be converting JSON to R objects, though.

[krlmlr]

Closing in favor of https://github.com/r-dbi/DBI/issues/203.

[github-actions]

This old thread has been automatically locked. If you think you have found something related to this, please open a new issue and link to this old issue if necessary.