r连mysql中文乱码_R语音-MySQL连接汉字乱码问题集解决

> conn

>  dbGetQuery(conn, "select * from t_data limit 0,10")

id_dat sub_station_no sub_station_name         sample_time water_temp ph doxy

1       1           5002              ??? 2013-12-31 22:00:00          9  8    8

2       2           5002              ??? 2013-12-31 20:00:00          9  8    8

3       3           5002              ??? 2013-12-31 18:00:00          9  8    8

4       4           5002              ??? 2013-12-31 16:00:00          9  8    8

5       5           5002              ??? 2013-12-31 14:00:00          9  8    8

6       6           5002              ??? 2013-12-31 12:00:00          9  8    8

7       7           5002              ??? 2013-12-31 10:00:00          9  8    8

8       8           5002              ??? 2013-12-31 08:00:00          9  8    8

9       9           5002              ??? 2013-12-31 06:00:00          9  8    8

10     10           5002              ??? 2013-12-31 04:00:00          9  8    8

> dbSendQuery(conn,'SET NAMES uft8')

Error in .local(conn, statement, ...) :

could not run statement: Unknown character set: 'uft8'

> dbSendQuery(conn,'SET NAMES uft-8')

Error in .local(conn, statement, ...) :

could not run statement: Unknown character set: 'uft'

> dbSendQuery(conn,'SET NAMES gbk')

>  dbGetQuery(conn, "select * from t_data limit 0,10")