I am totally new to R programming.I've got a database in MySQL and a column of this database include data in UTF-8 charset(Persian).
I did import the table from the database into the R studio with (RODBC), but the resulting character is not correct:
I did unique body col. and then changed its encoding, and it worked.
temp <- unique(postT$body),
temp2<- as.character(temp),
Encoding(temp2) <- "UTF-8"
but it cannot be a permanent solution. Since, then I cannot have any access to the whole dataset.
Also, I'd checked my ODBC connection setting here and it didn't work for me.
