R help - Jul 2011 - RMySQL, RODBC, dbReadTable and ISO-8859-1 (Spanish data)

Hello R users,

I am reading data into R from RMySQL or SQLite databases which are in
Spanish language. I am using RMySQL library and function dbReadTable but I
could not get characters with ñ and tilde, instead R does put ?.

In the past I could manage it modifying the R options as (using windows):

op <- options()
op$encoding <- "iso-8859-1"
options(op)

but now in ubuntu it did not work. I am working in ubuntu 10.04 and R
2.10.1.

I hope somebody could help me to figure it out.

Thanks,

Mario Martínez A.

	[[alternative HTML version deleted]]

Hola Mario,

No sé si finalmente pudiste solucionar el problema que planteaste, por si
todavía lo tienes te sugiero que incluyas el correo en la lista de ayuda de
R pero en español R-help-es.

Puedes darte de alta aquí:
https://stat.ethz.ch/mailman/listinfo/r-help-es

Saludos,
Carlos Ortega
www.qualityexcellence.es

On Fri, Jul 1, 2011 at 10:10 PM, Mario Martínez
<mma@mariomartinezaraya.com>wrote:
> Hello R users,
>
> I am reading data into R from RMySQL or SQLite databases which are in
> Spanish language. I am using RMySQL library and function dbReadTable but I
> could not get characters with ñ and tilde, instead R does put ?.
>
> In the past I could manage it modifying the R options as (using windows):
>
> op <- options()
> op$encoding <- "iso-8859-1"
> options(op)
>
> but now in ubuntu it did not work. I am working in ubuntu 10.04 and R
> 2.10.1.
>
> I hope somebody could help me to figure it out.
>
> Thanks,
>
> Mario Martínez A.
>
>        [[alternative HTML version deleted]]
>
>
> ______________________________________________
> R-help@r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide
> http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>
>
	[[alternative HTML version deleted]]