Hello,
I can't write data in a MySQL table with RMySQL anymore. I used to do this
until one year ago but since then it's broken, I always get the error : "Erreur
dans tolower(avail) : chaîne de charactères multioctets incorrecte 43" (meaning
in English : Error in tolower(avail) : incorrect multibyte string", it can be
something else than '43'). So I tried to narrow down to a simple case and I
made this script :
#!/usr/bin/Rscript
library(DBI)
library(RMySQL)
conn <- dbConnect("MySQL", user="userr", password="passworrd", dbname="dbtest")
res <- dbSendQuery(conn, statement = paste("SELECT * FROM testable"))
input <- fetch(res, n = -1)
dbWriteTable(conn, "testable2", input, row.names = T, overwrite = FALSE, append
= T)
dbDisconnect(conn)
The table content being :
id testval
1 1 76
2 2 47417
The user owns the DB. The fetch works fine but not the dbWriteTable. The error
is probably related to some character coding but I can't figure out what.
I'm using R version 3.0.2 (2013-09-25), RMySQL 0.9-3 and MySQL 5.6.14, Mac OS X
10.9.1 .
I have the same issue on Rstudio server hosted on a Debian machine.
Thanks for helping !
Didier
[[alternative HTML version deleted]]
_______________________________________________
R-SIG-Mac mailing list
[email protected]
https://stat.ethz.ch/mailman/listinfo/r-sig-mac
