Clever Geek Handbook

Special characters and RODBC

in the database I have strings that contain special characters like "§". Using the command

sqlQuery()

from the RODBC package "§" is translated to "?". This also applies to symbols such as "" as found in French words.

Of course, I can't replace all "?" one of the special characters after the request. Anyone have an idea on this issue? I am working under Windows 7.

As per the request to enter sessionInfo() 

R version 2.14.1 (2011-12-22)
Platform: x86_64-pc-mingw32/x64 (64-bit)

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] grid      stats     graphics  grDevices utils     datasets  methods   base     

other attached packages:
[1] timeDate_2160.97 gridExtra_0.9.1  reshape2_1.2.2   RODBC_1.3-6      ggplot2_0.9.3.1  plyr_1.8        
[7] Runiversal_1.0.2

loaded via a namespace (and not attached):
 [1] colorspace_1.2-1   dichromat_2.0-0    digest_0.6.3       gtable_0.1.2       labeling_0.1       MASS_7.3-21       
 [7] munsell_0.4        proto_0.3-10       RColorBrewer_1.0-5 scales_0.2.3       stringr_0.6.2      tools_2.14.1
+2


source to share


1 answer


If you see an issue where you are using sqlSave () in R to submit to MYSQL where not all data streams go through, this is most likely due to special characters. The key is to make sure the character collation is set the same in both. I found latin1 to work best.



0


source






More articles:


All Articles