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.