utf8 issue with latin characters containing acutes a

utf8 issue with latin characters containing acutes a

am 22.07.2010 22:10:58 von Daniel Jackson

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@m.gmane.o rg