Binary file to BLOB

Rails
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

can you try:

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

the important part being “rb” which means read the file directly as
binary data.

3

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.

4

Thanks, it works.