To Documents
Datatype Mappings
- Datatype mappings for the Databases most often used with Rails:
| Migration Type | Ruby Class | SQLite |
MySQL | Postgres | Oracle |
| :binary | String | blob |
blob | bytea | 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 |
varchar2(255) |
| :text | String | text |
text | clob(32768) | clob |
| :time | Time | time |
time | time | date |
| :timestamp | Time | datetime |
datetime | timestamp | date |
- Reference: Obie Fernandez, The Rails 3 Way, Addison-Wesley, 2011.