store image data in mySql database using rails

[News Aanad]

hi ,
I want to store image data in mySQL database using rails. 
I have created a table called "Photo_info" which have field called "photo_data" and the data type of that field is "varchar".
My code is:

 path = "C:/test_sqs/public/images/rails.png" 
   File.open(path, 'rb'){ |file| @data= file.read  }

When I am trying to store data in database, it gives error like:

"Could not log "sql.active_record" event. ArgumentError: invalid byte sequence in UTF-8"


what should i do?

[Frederick Cheung]

varchar is the wrong column type. It's almost certainly too short but
beyond that it's expecting text data, not arbitrary binary data. If
you want to store stuff like that in the database you should be using
a blob column (storing large files in the database isn't usually that
great of an idea though)

Fred

[News Aanad]

Thanks for Reply,
      But I want to do the same with amazon's SimpleDB which deals only with String.
How can i do that?

Thanks in Advance

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To post to this group, send email to rubyonra...@googlegroups.com.
To unsubscribe from this group, send email to rubyonrails-ta...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.

[Frederick Cheung]

On Apr 28, 11:03 am, News Aanad <news.anan...@gmail.com> wrote:
> Thanks for Reply,
>       But I want to do the same with amazon's SimpleDB which deals only with
> String.
> How can i do that?
>

I wouldn't if I were you - attribute values are capped at 1024 bytes.
If you want to store images in the amazon world, I'd use S3

Fred

[News Aanad]

Thank you Fred.