To Documents

Datatype Mappings

• Datatype mappings for the Databases most often uses with Rails:

  Migration Type	Ruby Class	SQLite	MySQL	Postgres	Oracle
  :binary	String	blob	blob	bloba	blob
  :boolean	Boolean	boolean	tinyint(1)	boolean	number(1)
  :date	Date	date	date	date	date
  :datetime	Time	datetime	datetime	timestamp	date
  :decimal	BigDecimal	decimal	decimal	decimal	decimal
  :float	Float	float	float	float	number
  :integer	Fixnum	integer	int(11)	integer	number(38)
  :string	String	varchar(255)	varchar(255)	character varying(255)	varchar2(255)
  :text	String	text	text	clob(32768)	clob
  :time	Time	time	time	time	time
  :timestamp	Time	datetime	datetime	timestamp	date

• Reference: Obie Fernandez, The Rails Way, Addison-Wesley, 2008.