Hello Liu, this might be caused by NA entries in your SQLite table. Have a look at the following code:
(test <- data.frame(matrix(c(1:10, NA, NA), ncol=2, nrow=6))) con <- dbConnect(SQLite(), dbname = "test.db") dbWriteTable(con, "test", test, type="BLOB", overwrite=TRUE) d1 <- dbReadTable(con, "test") dbDisconnect(con) d1 HTH, Bernhard -----Ursprüngliche Nachricht----- Von: Wensui Liu [mailto:[EMAIL PROTECTED] Gesendet: Samstag, 31. Dezember 2005 07:09 An: r-help@stat.math.ethz.ch Betreff: [R] Q about RSQLite Happy new year, dear listers, I have a question about Rsqlite. when I fetch the data out of sqlite database, there is something like '\r\n' at the end of last column. Here is the example: Sepal_Length Sepal_Width Petal_Length Petal_Width Species 1 5.1 3.5 1.4 0.2 setosa\r\n 2 4.9 3.0 1.4 0.2 setosa\r\n 3 4.7 3.2 1.3 0.2 setosa\r\n 4 4.6 3.1 1.5 0.2 setosa\r\n 5 5.0 3.6 1.4 0.2 setosa\r\n 6 5.4 3.9 1.7 0.4 setosa\r\n 7 4.6 3.4 1.4 0.3 setosa\r\n 8 5.0 3.4 1.5 0.2 setosa\r\n 9 4.4 2.9 1.4 0.2 setosa\r\n 10 4.9 3.1 1.5 0.1 setosa\r\n Any idea? Thank you so much [[alternative HTML version deleted]] ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html ***************************************************************** Confidentiality Note: The information contained in this mess...{{dropped}} ______________________________________________ R-help@stat.math.ethz.ch mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
