MySQL lookups on VARCHAR with accents

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

Set the collation you want to use (http://dev.mysql.com/doc/refman/5.0/en/charset-collation-effect.html)

Fred

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