Re: unicode case insensitive but diacritics sensitive

2014-11-25 Thread Martin Mueller
Thanks for that answer. It squares with my solution: have an additional column that has the lower case values of the case sensitive unicode setting. Martin Mueller Professor emeritus of English and Classics Northwestern University On 11/25/14 6:48 AM, "Rik" wrote: >Not a unicode one that

Re: unicode case insensitive but diacritics sensitive

2014-11-25 Thread Rik
Not a unicode one that I know of, converting it to latin1 for the grouping works for that particular use case, but I can't make any promises how it'd work on your entire set which may hold any unicode character, a lot of which cannot be converted to latin1: mysql> SET NAMES utf8; Query OK, 0 rows