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
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 r...@grib.nl wrote:
Not a unicode
Is there a unicode setting on mysql that is case insensitive but
diacritics sensitive? Given 'Ete', 'été', 'ete' a group by routine for
such a setting would return two values: 'été', 'ete'. I couldn't find
it, but I may not have known where to look.
Martin Mueller
Professor emeritus of