Loading binary data from a file using ActiveRecord Create

Question

Is there an easy (or generally accepted) way to load a binary column using the ActiveRecord create method?

For example, I'm trying to do something similar to this:

MyTableObject.create :name => "Test", :image => File.read("PathToMyFile.jpg")

+2

jerhinesmith 27 Aug 09 at 19:28

1 answer

jerhinesmith · Accepted Answer · 2009-08-27T20:58:59+0000

I was able to get this to work. Instead of doing:

MyTableObject.create(
    :name => "Test",
    :image => File.read("PathToMyFile.jpg")
)

which did insert a record into the database, but without the correct binary representation of the file

MyTableObject.create(
    :name => "Test",
    :image => File.open("PathToMyFile.jpg", 'rb').read
)

seemed to do the trick.