Ruby to SQL Type Conversion : Data Type « Development « Ruby






  1. Ruby
  2. Development
  3. Data Type

Ruby to SQL Type Conversion


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








Related examples in the same category

1.SQL to Ruby Type Conversion