RMariaDB icon indicating copy to clipboard operation
RMariaDB copied to clipboard

Documentation of differences between RMariaDB and RMySQL regarding data types?

Open florian-speer opened this issue 7 months ago • 2 comments

Hi, my team is currently trying to migrate from RMySQL to RMariaDB. For the biggest part it's working well, but we do have some trouble regarding the differences both packages have regarding the translation of MySQL data types to R data types. For example, MySQL DATETIME is loaded by RMySQL as character and by RMariaDB as POSIXct. These changes are totally reasonable, but currently our only way of noticing them is when errors are thrown on downstream function calls. I tried to find some documentation that covers these differences but couldn't find anything. Does something like this exists or would it be possible to create it?

florian-speer avatar Jul 17 '24 14:07 florian-speer