Unable to store Array of values to single db table column in rails 2.x?

Question

Html code is:

Utilities: <br>
<input type="checkbox" name="amenity[utilities][]" value="Gas">Gas<br>
<input type="checkbox" name="amenity[utilities][]" value="Electricity">Electricity<br>
<input type="checkbox" name="amenity[utilities][]" value="Water">Water<br>
<input type="checkbox" name="amenity[utilities][]" value="Parking">Parking<br>

The above html is storing data in DB Table column as below:

--- 
- Gas
- Electricity
- Parking
- Water

shivam · Accepted Answer · 2015-12-11 06:40:44Z

1

This is because Rails serialize objects to YAML in order to store it in database. What you are seeing is actually a YAML serialized array. Here:

require 'yaml'
dbstr = "--- 
- Gas
- Electricity
- Parking
- Water"
# => "--- \n- Gas\n- Electricity\n- Parking\n- Water"
YAML::load dbstr
# => ["Gas", "Electricity", "Parking", "Water"]

Also check the doc for ActiveRecord::Base#serialize

answered Dec 11, 2015 at 6:40

shivam

16.6k3 gold badges62 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Unable to store Array of values to single db table column in rails 2.x?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related