使用R语言将数据上传到mysql数据库出现如下错误：

Question

代码1：
conn <- dbConnect(MySQL(),host="12356",port=24658,dbname ="adbsjk",username = username,password = password)
dbSendQuery(conn,"SET NAMES gbk")
dbWriteTable(conn, name="test", value=myData)

错误1：Error in .local(conn, statement, ...) :
could not run statement: Invalid utf8 character string: ''

代码2：conn <- dbConnect(MySQL(),host="12356",port=24658,dbname ="adbsjk",username = username,password = password)
dbSendQuery(conn,"SET NAMES utf8")
dbWriteTable(conn, name="test", value=myData)

错误2：Error in .local(conn, statement, ...) :
could not run statement: Invalid utf8 character string: '\xCA\xA1\xB7\xDD\xC3\xFB\xB3\xC6'

数据上传后只有表头，内容全部是空的；

如有小伙伴知道解决方法，求告知~~~

Answer 1

conn <- dbConnect(MySQL(), dbname = "data", username="root", password="*********", host="127.0.0.1", port=3306)
username一般是root,然后dbname是你需要读取的表所在数据库的名字。

Answer 2

老兄，这个问题你解决没有呀。我也遇到同样的问题