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? TIA, 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
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 ) 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Quoting Frederick Cheung <frederick.cheung-Re5JQEeQqe8AvxtiuMwx3w@public.gmane.org>:> > > 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 rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---