Subject | Re: [firebird-support] Firebird 3.0.4 unicode_ci_ai index problems |
---|---|
Author | nonomura |
Post date | 2018-10-16T13:23:20Z |
>> 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
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.