[R] Windows / RODBC / Accented characters

[Yves Gauvreau]

The simplest suggestion I can give is to use an sql statement in which you
make use of "as newfieldname". This will will change the names of the table
columns and you should be ok.

Regards

YG

----- Original Message -----
From: "Charles RAUX" <Charles.Raux at let.ish-lyon.cnrs.fr>
To: "r-help" <r-help at stat.math.ethz.ch>
Sent: Monday, August 28, 2000 7:16 AM
Subject: [R] Windows / RODBC / Accented characters


> 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
>
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._.
_._

-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
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
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._