Rails Migration Data Types – MySql – Postgresql – SQLite

Rails	mysql	postgresql	sqlite
:binary	blob	bytea	blob
:boolean	tinyint(1)	boolean	boolean
:date	date	date	date
:datetime	datetime	timestamp	datetime
:decimal	decimal	decimal	decimal
:float	float	float	float
:integer	int(11)	integer	integer
:string	varchar(255)	*	varchar(255)
:text	text	text	text
:time	time	time	datetime
:timestamp	datetime	timestamp	datetime