Subject Re: [firebird-support] Firebird 3.0.4 unicode_ci_ai index problems
Author nonomura
>> CI AI indexes are much bigger because of ICU implementation of index key derivation.

Compareing those icu depending collations, CI AI is smallest.

http://demo.icu-project.org/icu-bin/collation.html

Input
-------
ç
C
c

Sort case 1 with sort keys: strength=default (equivalent of collate unicode)

Output
-------
c
    2D , 05 , 05 .
C
    2D , 05 , DC .
ç
    2D , 45 A0 , 06 .


Sort case 2 with sort keys: strength=primary (equivalent of collate unicode_ci_ai)

Output
-------
ç
    2D .
C
    2D .
c
    2D .


Sort case 3 with sort keys: strength=secondary (equivalent of collate unicode_ci)

Output
-------
C
    2D , 05 .
c
    2D , 05 .
ç
    2D , 45 A0 .



Hiro


(2018/10/16 2:08), Dimitry Sibiryakov sd@... [firebird-support] wrote:
   CI AI indexes are much bigger because of ICU implementation of index key derivation. 
You must increase page size of your database to return index depth to norm.