utf8 issue with latin characters containing acutes a

Running this query:

SELECT *
FROM `tbl_people`
WHERE name =3D 'Dav=E9'

Returns results like:

'Dave'


I've checked my column, table and database and all are set to
utf8_general_ci collation

And I'm also runnig set names 'utf8' before my select statement.


Am I missing something obvious, I've had a google and others seem to
have the same issue:

http://lists.mysql.com/mysql/209885
http://bugs.mysql.com/bug.php?id=3D42126


Any help appreciated,

Cheers.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2 [at] m.gmane.o rg
Daniel Jackson [ Do, 22 Juli 2010 22:10 ] [ ID #2044941 ]
Datenbanken » gmane.comp.db.mysql.general » utf8 issue with latin characters containing acutes a

Vorheriges Thema: combined or single indexes?
Nächstes Thema: Why Does This Drop Fail?