Subject | Re: Firebird 3.0.4 unicode_ci_ai index problems |
---|---|
Author | |
Post date | 2018-10-15T21:49:52Z |
The problem is that multy-level collations can't be used for full match in indices.
If you need details, search fb-devel for thread "UNICODE case/accent insensitive bugs" started at 10 Jun 2009.
See also CORE-2457
As a workaround, you might try to use two single-segment indices instead of one multy-segment.
Regards,
Vlad