Skip to content

RMysql encoding utf8 issue #205

Open
@rishabasthana5144

Description

@rishabasthana5144

I am trying to extract data from Mysql database using RMysql packages in R. The data gets imported into r with the changed encoding format where in "Córdoba" in UTF-8 gets changed to "Córdoba".
I have tried to set names as utf8 as per the suggestion but with no luck.
Here is the command for it:

dbGetQuery(mydb,"set names utf8")

My Session info

sessionInfo()
R version 3.4.0 (2017-04-21)
Platform: x86_64-w64-mingw32/x64 (64-bit)
Running under: Windows 7 x64 (build 7601) Service Pack 1

Matrix products: default

locale:
[1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252
[3] LC_MONETARY=English_United States.1252 LC_NUMERIC=C
[5] LC_TIME=English_United States.1252

attached base packages:
[1] parallel stats graphics grDevices utils datasets methods base

other attached packages:
[1] stringr_1.2.0 RMySQL_0.10.11 DBI_0.6-1 dplyr_0.7.0 properties_0.0-8 itertools_0.1-3
[7] doParallel_1.0.10 iterators_1.0.8 foreach_1.4.3 reshape2_1.4.2 haven_1.0.0

loaded via a namespace (and not attached):
[1] Rcpp_0.12.11 codetools_0.2-15 assertthat_0.2.0 R6_2.2.1 plyr_1.8.4 magrittr_1.5
[7] rlang_0.1.1 stringi_1.1.5 tools_3.4.0 glue_1.0.0 compiler_3.4.0 tibble_1.3.3

It looks some fundamental thing is missing from my end. Looking for a resolution from someone. Kindly help please.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions