MySQL 4.1.22 seems to treat the following characters as equal
(comparing them as varchar values):
U+03B7 (206 183) greek small letter eta
U+1F75 (225 189 181) greek small letter eta with accent oxia
U+1FC4 (225 191 135) greek small letter eta with accent persispomeni
and accent
Sven Fuchs wrote:
These characters are stored/retrieved correctly. But they are wrongly
regarded the same character by statements like SELECT * FROM tablename
WHERE fieldname LIKE '[greek small eta]'
The database's character-set is set to UTF-8 Unicode (utf8) and the
table's and varchar
Am 05.02.2007 um 18:11 schrieb Chris White:
SELECT * FROM tablename WHERE fieldname LIKE BINARY '[greek small
eta]'
that *should* ( see disclaimer ;) ) give you what you need
Yes, it does.
I should have also asked for SELECT DISTINCT fieldname ... in the
first place, but looking at your