[R] RODBC type conversion bug

Omar Lakkis uofiowa at gmail.com
Wed Feb 23 17:30:53 CET 2005


I run R 2.0.1 on Debian and connect to Informix database via RODBC. In
the table below the column "month" is of type char(1). RODBC seems to
be converting this column to boolean if the value is F or T.

This is the data in my table:

       id month year
      25         F 2005
      26         Z 2005

When I select * for id 25 I get
25 FALSE 2005

When I select * for id 16 I get
26    Z 2005

Is there a fix for this issue?

I invoke odbc connect with: db <- odbcConnect("mydb", believeNRows=FALSE)




More information about the R-help mailing list