MySQL lookups on VARCHAR with accents

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

On 3 Sep 2008, at 00:35, Jeffrey L. Taylor wrote:

±------±------+
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

Quoting Frederick C. [email protected]:

±------±------+

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

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs