Hi Jia,

On Mon, Feb 28, 2011 at 12:37 PM, chen jia <chen_1...@fisher.osu.edu> wrote:
> When I extract data from SQLite to R, the data types (or modes) of the
> extracted data seems to be determined by the value of the first row.
> Please see the following example.

It would help to provide the output of sessionInfo() as well as the
schema definition for the table in SQLite (or at least description of
how it was created).

Here's an example that works as you'd like:

    > library(RSQLite)
    > db = dbConnect(SQLite(), dbname = ":memory:")
    > dbGetQuery(db, "create table t (a int, b real, c text)")
    > df = data.frame(a=c(NA, 1L, 2L), b=c(NA, 1.1, 2.2), c=c(NA, "x",
"y"),stringsAsFactors=FALSE)
    > df
       a   b    c
    1 NA  NA <NA>
    2  1 1.1    x
    3  2 2.2    y
    > dbGetPreparedQuery(db, "insert into t values (?, ?, ?)", df)
    > dbGetQuery(db, "select * from t")
       a   b    c
    1 NA  NA <NA>
    2  1 1.1    x
    3  2 2.2    y
    > sapply(dbGetQuery(db, "select * from t"), typeof)
              a           b           c
      "integer"    "double" "character"
    > sapply(dbGetQuery(db, "select * from t limit 1"), typeof)
              a           b           c
      "integer"    "double" "character"
    > sapply(dbGetQuery(db, "select a from t limit 1"), typeof)
            a
    "integer"
    > sapply(dbGetQuery(db, "select a from t limit 2"), typeof)
            a
    "integer"
    > sapply(dbGetQuery(db, "select a from t limit 1"), typeof)
            a
    "integer"


> sessionInfo()
R version 2.11.1 (2010-05-31)
x86_64-apple-darwin9.8.0

locale:
[1] en_US.UTF-8/en_US.UTF-8/C/C/en_US.UTF-8/en_US.UTF-8

attached base packages:
[1] stats     graphics  grDevices datasets  utils     methods   base

other attached packages:
[1] RSQLite_0.9-4 DBI_0.2-5

loaded via a namespace (and not attached):
[1] tools_2.11.1




-- 
Seth Falcon | @sfalcon | http://userprimary.net/

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to