(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

Reply via email to