binary file to BLOB

rubyonrails-talk
1

I need to put image files from filesystem to mysql database. I don't have to upload images, they are in the server filesystem already. I tried such code in my model , but it don't work:

        f = File.open(File.join(iconDirPath, filename))         data = Mysql.escape_string(f.read())         self.icon = data         self.save

Model "Document" has binary field :icon, where I tried to save data from file, but it only save small portion (190 - 400 bytes).

Please, help.

2

sorry I accidently posted my reply to just the author. I think this might help:

self.icon = File.open(File.join(iconDirPath, filename) , "rb").read

The important bit is "rb" which means read the files as binary data.

3

Thanks, it works.