AUTHORS
- Michael Chu (212)
- Tina Jiang (3)
CATEGORIES
- Airsoft (2)
- Books (9)
- Cooking For Engineers (18)
- Current Events (9)
- Deals (3)
- Dining (12)
- Fanpop (3)
- Food (32)
- Games (4)
- Life (20)
- Movies (15)
- Orthogonal Thought (3)
- Personal Computers (4)
- Photography (4)
- Rant (6)
- Ruby on Rails (2)
- San Francisco (1)
- Soap Making (3)
- Television (2)
- Travel (3)
- Wear or Not (1)
- Web 2.0 (8)
- What I Ate (92)
- Windows Mobile (1)
- WordPress (1)
ARCHIVE
- September 2008 (1)
- August 2008 (5)
- July 2008 (5)
- June 2008 (11)
- May 2008 (13)
- April 2008 (10)
- March 2008 (29)
- February 2008 (18)
- January 2008 (28)
- December 2007 (1)
- November 2007 (4)
- October 2007 (5)
- September 2007 (10)
- August 2007 (14)
- July 2007 (10)
- June 2007 (9)
- May 2007 (21)
- April 2007 (21)
ACTIONS
MySQL and Ruby on Rails datatypes
Posted 29 June, 2007 at 12:36pm by Michael Chu(Filed under: Ruby on Rails, Web 2.0)
One of the best features of Ruby on Rails is the ability to interact with database tables as objects using ActiveRecord. Sometimes documentation can be a bit spotty, but after searching for a little bit it’s not hard to find the mapping from Rails Migration types to MySQL data types. I did find it more difficult to find out what happens if I already have an existing MySQL table. What Ruby class gets created with what MySQL column type? I didn’t find it on the web, so I put together this list…
I added links to MySQL documentation for each of the MySql data types and links to the relevant Ruby class type to make this table a bit more useful.
MySQL Column Data Type to Ruby class type (when using ActiveRecord)
For completeness sake, here’s a summary of Rails migration types and their MySQL column data types.
Rails Migration Type to MySQL Column Data Type
| Rails Migration Symbol | MySQL Data Type |
|---|---|
| :binary | blob |
| :boolean | tinyint(1) |
| :date | date |
| :datetime | datetime |
| :decimal | decimal |
| :float | float |
| :integer | int(11) |
| :string | varchar(255) |
| :text | text |
| :time | time |
| :timestamp | datetime |
5 comments to MySQL and Ruby on Rails datatypes
Free as in Time » Blog Archive » RoR Tuesday 03/07/2007, July 11th, 2007 at 8:37 am:
-
[…] MySQL and Ruby on Rails datatypes - Sweet resource. One of the best features of Ruby on Rails is the ability to interact with database tables as objects using ActiveRecord. Sometimes documentation can be a bit spotty, but after searching for a little bit it’s not hard to find the mapping from Rails Migration types to MySQL data types. I did find it more difficult to find out what happens if I already have an existing MySQL table. What Ruby class gets created with what MySQL column type? I didn’t find it on the web, so I put together this list… […]
viktor, August 30th, 2007 at 4:28 am:
-
This is nice, but it seems like a flaw that Ruby on rails is incapable of managing the “double” data type..
I know that there is a patch avaliable: http://dev.rubyonrails.org/ticket/7594 .
Will that ever be a part of the standard RoR package ?
Tipos de datos Ruby on Rails a MySQL « Leobrambilla Weblog, August 30th, 2007 at 1:31 pm:
-
[…] Esta es una info que me costo un poco encontrar por eso la comparto. Son los datos a cargar en el Modelo generado por […]
links for 2008-03-24 « Web Flakes, March 23rd, 2008 at 8:17 pm:
-
[…] MySQL and Ruby on Rails datatypes (tags: rails.datatypes) […]
digital subterfuge » Blog Archive » Apples and Oranges. Er, RoR and MySQL data types., May 12th, 2008 at 10:09 pm:
-
[…] This site has a handy chart to tell you. […]