On 19/10/2018 09:42, nonomura wrote: > (2018/10/19 19:03), Adriano dos Santos Fernandes wrote: >> ICU generates sort key for a single string. For multi segment >> (columns) index/sort, Firebird call ICU (or any collation) for each >> column and join the generated fully (with all levels/strengths) sort >> keys. To generate interleaved keys and joins them in another manner, >> Firebird INTL interface should be changed, so Firebird could ask a >> collation for the sort key's levels/strengths separated. > > Ok, somewhat understood. > But I still don't get why you think there is need to do it in another > manner. > Is it no good only to remove the condition whether it is unique or not? >
I already showed to you that UNICODE (sensitive) has the problem, and it does not nor can't use this condition. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel