Rails 3 datatypes?
Here are all the Rails3
(ActiveRecord migration) datatypes:
:binary
:boolean
:date
:datetime
:decimal
:float
:integer
:primary_key
:references
:string
:text
:time
:timestamp
Source
It is important to know not only the types but the mapping of these types to the database types, too:
For, example, note that in MS SQL Server we are using:
- the old "datetime" instead "datetime2"
- decimal with its default precision
- text and varchar instead nvarchar
- int (not possible to use tiny int/small int/big int)
- image instead BLOB