Guest User

Untitled

a guest
Nov 7th, 2016
64
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.18 KB | None | 0 0
  1. con <- dbConnect(RMySQL::MySQL(), host = "***",dbname="***",user = "***", password = "***")
  2.  
  3. dbGetQuery(con,"set names utf8")
  4.  
  5. Q1 <- dbSendQuery(con, "SELECT * FROM cities")
  6.  
  7. city <- fetch(Q1, n = -1)
  8.  
  9. > Encoding(city$name) %>% table()
  10. .
  11. unknown
  12. 45734
  13.  
  14. > Encoding(city$name) <- "UTF-8"
  15. > Encoding(city$name) %>% table()
  16. .
  17. unknown UTF-8
  18. 44920 814
  19.  
  20. > library(stringi)
  21. Warning message:
  22. package โ€˜stringiโ€™ was built under R version 3.3.2
  23. > all(stri_enc_isutf8(city$name))
  24. [1] FALSE
  25.  
  26. > sessionInfo()
  27. R version 3.3.1 (2016-06-21)
  28. Platform: x86_64-w64-mingw32/x64 (64-bit)
  29. Running under: Windows >= 8 x64 (build 9200)
  30.  
  31. locale:
  32. [1] LC_COLLATE=English_United States.1252 LC_CTYPE=English_United States.1252
  33. [3] LC_MONETARY=English_United States.1252 LC_NUMERIC=C
  34. [5] LC_TIME=English_United States.1252
  35.  
  36. attached base packages:
  37. [1] stats graphics grDevices utils datasets methods base
  38.  
  39. other attached packages:
  40. [1] stringi_1.1.2 tidyr_0.5.1 purrr_0.2.2 dplyr_0.5.0 RMySQL_0.10.9 DBI_0.4-1
  41.  
  42. loaded via a namespace (and not attached):
  43. [1] magrittr_1.5 R6_2.1.2 assertthat_0.1 tools_3.3.1 tibble_1.1 Rcpp_0.12.6
Add Comment
Please, Sign In to add comment