Migration and Database Column Types (Rails)

from Agile Web Development with Rails by Thomas & Hansson

	mysql	postgresql	sqlite	sybase
:binary	blob	bytea	blob	image
:boolean	tinyint(1)	boolean	boolean	bit
:date	date	date	date	datetime
:datetime	datetime	timestamp	datetime	datetime
:decimal	decimal	decimal	decimal	decimal
:float	float	float	float	float(8)
:integer	int(11)	integer	integer	int
:string	varchar(255)	(note 1)	varchar(255)	varchar(255)
:text	text	text	text	text
:time	time	time	datetime	time
:timestamp	datetime	timestamp	datetime	timestamp