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 field's collation is set "utf8_unicode_ci".
Is there anything I can do to have MySQL distinguish these characters?
DISCLAIMER: not tested
try something like:
SELECT * FROM tablename WHERE fieldname LIKE BINARY '[greek small eta]'
that *should* ( see disclaimer ;) ) give you what you need
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]