(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?
Hiro
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel