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 |
Related Posts
Posted on April 19, 2009 at 2:39 pm by Jordan Carter · Permalink
In: Uncategorized · Tagged with: migrations, mysql, postgresql, sqlite
In: Uncategorized · Tagged with: migrations, mysql, postgresql, sqlite
