MySQL lookups on VARCHAR with accents

rubyonrails-talk
1

I am running into problems with MySQL and lookups. The table has character set utf8, but:

2

Set the collation you want to use (MySQL :: MySQL 8.0 Reference Manual :: 10.8.6 Examples of the Effect of Collation)

Fred

3

Quoting Frederick Cheung <frederick.cheung@gmail.com>:

> > I am running into problems with MySQL and lookups. The table has
> character > set utf8, but: > > > 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