Ruby/Development/Data Type

Ruby Type                                    SQL Type
NilClass (nil)                               NULL
TrueClass, FalseClass (true, false)          CHAR(1), BOOL
String                                       VARCHAR, CHAR, TEXT
Integer (Fixnum or Bignum)                   INT, BIGINT
Float                                        FLOAT, DOUBLE, REAL
DBI::Binary                                  BLOB, CLOB, LONG, LONG RAW
DBI::Time (or String)                        TIME
DBI::Date (or String)                        DATE
DBI::Timestamp (or String)                   TIMESTAMP

SQL Type                   Ruby Type
BOOL                       TrueClass, FalseClass ( or String)
VARCHAR, CHAR              String
INT, BIGINT                Integer (Fixnum or Bignum)
FLOAT, DOUBLE, REAL        Float
BLOB, CLOB, LONG, LONG RAW String
TIME                       DBI::Time (or String)
DATE                       DBI::Date (or String)
TIMESTAMP                  DBI::Timestamp (or String)