Ruby/Development/Data Type

Материал из Wiki.crossplatform.ru

Перейти к: навигация, поиск

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



SQL to Ruby Type Conversion

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)