Store image data in mySql database using rails

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?

On Apr 28, 9:34am, News A. [email protected] wrote:

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

what should i do?

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

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

On Thu, Apr 28, 2011 at 2:35 PM, Frederick C. <

On Apr 28, 11:03am, News A. [email protected] 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

Thank you Fred.

On Thu, Apr 28, 2011 at 4:35 PM, Frederick C. <

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs