[R-sig-DB] FW: R encoding question

[Xiaobo Gu]

Xiaobo.Gu

-----Original Message-----
From: Xiaobo Gu [mailto:guxiaobo1982 using gmail.com] 
Sent: Wednesday, November 24, 2010 10:19 PM
To: r-help using r-project.org
Subject: R encoding question

Hi,
 I am using RpgSQL to retrieve data from a PostgreSQL database wich is with
encoding UTF8, and I have some Chinese character in one of the columns,
unfortunately R can't show it correctly.

> df <- dbGetQuery(con, "select * from test") df
  a            b
1 1 椤惧�娉\xa2
2 2   瑕� EURO\xa1

I see the following option, do I need to change the encoding option to show
the corresponding texts? In my case how to set?

$encoding
[1] "native.enc"

Thanks,
Xiaobo Gu