On Apr 28, 11:03 am, News Aanad <[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 > Thanks in Advance > > On Thu, Apr 28, 2011 at 2:35 PM, Frederick Cheung < > > > > [email protected]> wrote: > > > On Apr 28, 9:34 am, News Aanad <[email protected]> wrote: > > > 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? > > > 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 > > > -- > > 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 [email protected]. > > To unsubscribe from this group, send email to > > [email protected]. > > For more options, visit this group at > >http://groups.google.com/group/rubyonrails-talk?hl=en. -- 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 [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
