A new version of RSQLite has been pushed to CRAN.
In this version...
* Further integration of the manifest type system available since
SQLite 3. We now obtain the column type from the DB instead of
pulling everything across as a character vector and calling
type.convert. This should
That is a bug, namely, the default end of line on the windows version
should be \r\n instead of \n. The workaround is to specify
eol=\r\n in dbWriteTable(), e.g.,
dbWriteTable(con, DF, df, eol = \r\n)
dbReadTable(con, DF)
Hope this helps,
--
David
PS The object .Platform includes
What am I doing wrong, or is the \r that I'm getting
in the example below a bug?
a - (1:10)
b - (LETTERS[1:10])
df - as.data.frame(cbind(a, b))
df
a b
1 1 A
2 2 B
3 3 C
4 4 D
5 5 E
6 6 F
7 7 G
8 8 H
9 9 I
10 10 J
library(RSQLite)
drv - dbDriver(SQLite)
con -
]
Subject: [R] \r with RSQLite
What am I doing wrong, or is the \r that I'm getting
in the example below a bug?
a - (1:10)
b - (LETTERS[1:10])
df - as.data.frame(cbind(a, b))
df
a b
1 1 A
2 2 B
3 3 C
4 4 D
5 5 E
6 6 F
7 7 G
8 8 H
9 9 I
10 10 J
library
PROTECTED]
[mailto:[EMAIL PROTECTED] On
Behalf Of Mikkel Grum
Sent: Wednesday, March 15, 2006 1:46 PM
To: r-help@stat.math.ethz.ch
Cc: [EMAIL PROTECTED]
Subject: [R] \r with RSQLite
What am I doing wrong, or is the \r that I'm
getting
in the example below a bug?
a - (1:10)
b
Version 0.4-1 of the RSQLite package has been uploaded to CRAN.
RSQLite embeds the SQLite engine in R (see http://www.sqlite.org)
Changes include:
* Fixed problems exporting/importing NA's
* An new experimental dbWriteTable() method to create SQLite tables
from simple files (delimited