Hi,
On 2011/02/06, at 13:19, Xiaobo Gu wrote:
| 1. If there are text data with Chinese character, then data
will not
| be inserted into database server even there is only one column
of the
| dataframe.
| 2. I can send you the sample data which can't be inserted.
It seems there are other problems than encoding, the columns with
Chinese character have been removed from the sample data I sent, but
the remaining columns still can't get inserted into database server.
If so, you can track down to a single record that prevents
insertion, and present an R transaction showing how it fails.
Including, what you typed into R console, response by R including the
error message and how you know that it is not inserted.
Without real example, there is no way to help as Dirk suggested in
the previous mail.
At least,
http://r.789695.n4.nabble.com/Package-RPostgreSQL-Problem-with-
dbWriteTable-td2195653.html#a2221189
is apparently unrelated, as it is clearly the problem of pathname
transmission, which is not
in current code.
http://code.google.com/p/rpostgresql/issues/detail?id=10&can=1
--
Tomoaki NISHIYAMA
Advanced Science Research Center,
Kanazawa University,
13-1 Takara-machi,
Kanazawa, 920-0934, Japan
_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB@r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-db
