[R] SQLite: When reading a table, a "\r" is padded onto the last column. Why?

Søren Højsgaard Soren.Hojsgaard at agrsci.dk
Wed Jan 3 02:23:29 CET 2007


Hi,
 
I put the iris data into a SQLite database with 
 
dbWriteTable(con, "iris", iris, row.names=F, overwrite = T)

Then I retrieve data from the database with 
 
rs  <- dbSendQuery(con, "select * from iris")
d1  <- fetch(rs)
dbClearResult(rs)

Then I get 
> head(d1)
  Sepal_Length Sepal_Width Petal_Length Petal_Width  Species
1          5.1         3.5          1.4         0.2 setosa\r
2          4.9         3.0          1.4         0.2 setosa\r
3          4.7         3.2          1.3         0.2 setosa\r
4          4.6         3.1          1.5         0.2 setosa\r
5          5.0         3.6          1.4         0.2 setosa\r
6          5.4         3.9          1.7         0.4 setosa\r

Can anyone explain the extra "\r" at the end?  I am on Windows XP using R 2.4.1
Thanks in advance
Søren



More information about the R-help mailing list