how to set charset for MySQL in RODBC
- by lokheart
I have a data with chinese characters as field names and data, I have imported them from xls to access 2007 and export them to ODBC. Then I use RODBC to read them in R, the field names is OK, but for the data, all of the chinese characters are shown as ?.
I have read the RODBC manual and it said:
If it is possible to set the DBMS or ODBC driver…