Quoting Anubhaw Prakash <[email protected]>: > > Jeffrey L. Taylor wrote: > > Quoting Anubhaw Prakash <[email protected]>: > >> > >> Hi all. > >> I am having trouble in reading string containing special characters from > >> file and storing them in database. For example, for string like > >> '\x89\xA5\xCFI w...' > >> it throws error "Incorrect string value". The string should be wrappped > >> in duoble quotes, but i didn't find any method to do so. If any one has > >> solution please help. I need it very badly. > > > > Which database and what character set, e.g. UTF-8, Latin1, ASCII? Rails > > now > > defaults to UTF-8, but most databases default to Latin1. > > > > Jeffrey > > Database is MySql and character set is UTF-8 default. > > Anubhaw > Thanks.
The first character is a control code in UTF-8, HTJ. I've tried assigning and saving the above character strings in the Rails console. The saved and retrieved string is empty, but I'm not seeing the error "Incorrect string value". What is throwing this error? I also don't understand the part about wrapping in double quotes. Why can't you modify your program to change single to double quotes? Jeffrey --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
