(2018/10/19 20:18), Dimitry Sibiryakov wrote:
AFAIK, sorting key is just an array of bytes and sorting comparison routine treat it as an array of bytes. Key generation routine transform any data into an array of bytes and after that operation source data type is irrelevant.
I understood that once a sorting key was generated for a collate, the key is applicable only to the collate. If so, the root of the problem is that wrong parameter is given in the function to generate sorting key for unicode_ci, unicode_ci_ai where the ordering columns combination is not of unique index.
Please correct me if this is wrong. Regards, Hiro Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
