On 11/5/21 2:36 PM, Pavel Cisar wrote:
For example: The key "HROCH" (Czech word for hippopotamus) could have
sortkey: 13+27+23+14 (each letter replaced with byte representing it's
order place in alphabet, which is simplification for this showcase,
i.e. 13=H 27=R 23=O 14=CH)
If you would look for STARTING WITH "HROC" (or LIKE "HROC%"), you have
a partial key that would transform to sortkey: 13+27+23+4 (4=C) which
will not match "HROCH", but match "HROCENI" (roaring). This is
actually correct from Czech language POV, but not from IT POV when you
work on character level of characters defined in charset.
Pavel - how this SHOULD be in firebird from big clients POV?
STARTING WITH "HROC" should return only HROCENI or HROCH too?
Before changing / fixing something we should first of all decide what
result do we really need.
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
