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 |
