Thank you Fred. On Thu, Apr 28, 2011 at 4:35 PM, Frederick Cheung < [email protected]> wrote:
> > > 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. > > -- 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.
