[R] Windows / RODBC / Accented characters

Charles RAUX Charles.Raux at let.ish-lyon.cnrs.fr
Mon Aug 28 13:16:10 CEST 2000


A disturbing behaviour of R: an import of data using RODBC library 
(Windows 98, R 1.1.1) recognizes accented characters in variables 
names but these can't be manipulated further. See below:
> library(Rodbc)
> ch<-odbcConnect("Paradox Files")
> pollut<-sqlFetch(ch,Pollutio)
> pollut
  Mortalité Densité Pollution
1        82     600       110
2        97     960       140
3        76     570        90
......
> attach(pollut)
> summary(Pollution)
   Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
     90     120     160     160     190     250 
> summary(Mortalité)
Error: syntax error

Is there another solution than changing the names of the fields under 
Paradox. Or RODBC package should be enhanced to automatically change 
the accented characters?

---------------
Charles RAUX,
Laboratoire d'Economie des Transports
CNRS-Université Lumière Lyon 2-ENTPE
email : charles.raux at let.ish-lyon.cnrs.fr
http://www.ish-lyon.cnrs.fr/let
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._



More information about the R-help mailing list