[R-sig-DB] timestamp support

Seth Falcon @|@|con @end|ng |rom |hcrc@org
Fri Sep 29 20:12:02 CEST 2006


Dirk Eddelbuettel <edd using debian.org> writes:

> On 29 September 2006 at 12:44, Jeffrey Horner wrote:
> | But I do get the following message when calling dbGetQuery() when a 
> | table contains the timestamp type:
> | 
> | 1: RS-DBI driver warning: (unrecognized MySQL field type 7 in column 2 
> | imported as character)
> | 2: RS-DBI driver warning: (unrecognized MySQL field type 7 in column 2 
> | imported as character)
>
> Turns out that I use timestamp quite heavily right now, and to the best of
> limited knowledge timestamps are
>
> -- not supported by DBI and RMySQL/ RSQlite
> -- not supported by Rdbi and RdbiPgSQL
>
> but are 
>
> -- supported natively by RODBC
>
> so I am back to using RODBC even though I dislike having to twiddle with
> odbc.ini and friends.

I will put this on the TODO list.  Patches, of course, are welcome :-)

+ seth

-- 
Seth Falcon | Computational Biology | Fred Hutchinson Cancer Research Center
http://bioconductor.org




More information about the R-sig-DB mailing list