store image data in mySql database using rails

rubyonrails-talk
1

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?

2

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

3

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

4

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

5

Thank you Fred.