# File UPLOAD and put it on a DB BLOB **URL:** \ **Category:** Rails\ **Created:** [June 17, 2009, 3:22pm UTC](https://www.ruby-forum.com/t/file-upload-and-put-it-on-a-db-blob/170427 "2009-06-17T15:22:19Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![bakkhoz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/d6d6ee/32.png) [@bakkhoz](https://www.ruby-forum.com/u/bakkhoz)\ **Post date:** [June 17, 2009, 3:22pm UTC](https://www.ruby-forum.com/t/file-upload-and-put-it-on-a-db-blob/170427/1 "2009-06-17T15:22:19Z")
@contact = Contact.new @contact.file\_file\_name=params[:contact][:file].original\_filename @contact.file\_content\_type=params[:contact][:file].content\_type.chomp @contact.file=params[:contact][:file].read @contact.save the first two elements work, @contact.file=params[:contact][:file].read results empty, can you say me where I am wrong. Sergio ---
**Author:** ![bakkhoz](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/d6d6ee/32.png) [@bakkhoz](https://www.ruby-forum.com/u/bakkhoz)\ **Post date:** [June 17, 2009, 4:55pm UTC](https://www.ruby-forum.com/t/file-upload-and-put-it-on-a-db-blob/170427/2 "2009-06-17T16:55:04Z")
Hi Sergio, It looks like you’re using Paperclip, based on the “file\_name\_name” and “file\_content\_type” etc., attributes? Is this right? I’m not sure… if you’re not, you should try Paperclip. I wrote an extension to Paperclip to handle saving to a DB BLOB; see [http://patshaughnessy.net/paperclip-database-storage](http://patshaughnessy.net/paperclip-database-storage) Here’s a tutorial/example on how to save a file as a BLOB: [http://patshaughnessy.net/2009/5/29/paperclip-sample-app-part-3-saving-file-attachments-in-a-database-blob-column](http://patshaughnessy.net/2009/5/29/paperclip-sample-app-part-3-saving-file-attachments-in-a-database-blob-column) - pat On Jun 17, 9:21 am, Sergio A. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)