Quoting Frederick Cheung <[EMAIL PROTECTED]>: > > > On 3 Sep 2008, at 00:35, Jeffrey L. Taylor wrote: > > > > > I am running into problems with MySQL and lookups. The table has > > character > > set utf8, but: > > > > mysql> select id, token from tokens where token = 'esta'; > > +-------+-------+ > > | id | token | > > +-------+-------+ > > | 83417 | está | > > +-------+-------+ > > 1 row in set (0.00 sec) > > > > How do I configure things so MySQL doesn't ignore accents? > > Set the collation you want to use > (http://dev.mysql.com/doc/refman/5.0/en/charset-collation-effect.html > ) >
There were several problems adding noise, but the real problem is that there is a bug in FeedTools 0.2.26 and probably beyond. It converts numeric HTML entities under 256 to Latin-1 characters, even though the feed was UTF-8. MySQL truncates strings (VARCHAR) on the first invalid UTF-8 character. 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 -~----------~----~----~----~------~----~------~--~---
