[Rails]資料庫可以使用哪些資料型態?如何存array,json ?

Here are all the Rails 4 (ActiveRecord migration) datatypes:

• :binary
• :boolean
• :date
• :datetime
• :decimal
• :float
• :integer
• :bigint
• :primary_key
• :references
• :string
• :text
• :time
• :timestamp

Source: http://api.rubyonrails.org/classes/ActiveRecord/ConnectionAdapters/SchemaStatements.html#method-i-add_column
These are the same as with Rails 3.

If you use PostgreSQL, you can also take advantage of these:

• :hstore
• :json
• :array
• :cidr_address
• :ip_address
• :mac_address

They are stored as strings if you run your app with a not-PostgreSQL database.

Edit, 2016-Sep-19:

There's a lot more postgres specific datatypes in Rails 4 and even more in Rails 5.

from:http://stackoverflow.com/questions/17918117/rails-4-list-of-available-datatypes