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