# Using :binary columns in models

**URL:** <https://www.ruby-forum.com/t/using-binary-columns-in-models/133114>\
**Category:** Rails\
**Created:** [March 28, 2008, 12:07am UTC](https://www.ruby-forum.com/t/using-binary-columns-in-models/133114 "2008-03-28T00:07:26Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Col\_W](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/dec6dc/32.png) [@Col\_W](https://www.ruby-forum.com/u/Col_W)\
**Post date:** [March 28, 2008, 12:07am UTC](https://www.ruby-forum.com/t/using-binary-columns-in-models/133114/1 "2008-03-28T00:07:26Z")

</div>

I am creating little personal flags for each user and since they are  
small I think it would be best to store them as a blob (:binary), but  
I can’ find anything that i understand.

Can anyone point me at a tutorial on handling images in rails?

---

<div class="post-metadata">

**Author:** ![Col\_W](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/dec6dc/32.png) [@Col\_W](https://www.ruby-forum.com/u/Col_W)\
**Post date:** [March 28, 2008, 6:21am UTC](https://www.ruby-forum.com/t/using-binary-columns-in-models/133114/2 "2008-03-28T06:21:48Z")

</div>

Yes , You can simply save the image in the database.  
Add a column in a table having type BLOB.

in comtroller take a object of the table let us say Image

table = Image.new  
table.image = “image”  
table.save()

Thanks  
Ekta

On Mar 28, 4:06 am, Col W. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![Col\_W](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/dec6dc/32.png) [@Col\_W](https://www.ruby-forum.com/u/Col_W)\
**Post date:** [March 31, 2008, 9:34am UTC](https://www.ruby-forum.com/t/using-binary-columns-in-models/133114/3 "2008-03-31T09:34:29Z")

</div>

Thanks.