Omacht András wrote 06.11.2021 14:08:
Maybe if you find double letters you handled them together when you sort and you handled them separated when you search.
Unfortunately comparison is used for sorting and sorting is used for indexes and indexes are used for search so they cannot have different rules. But I believe that different collations can have different rules for comparison so you can sort using one collation and search using another.
-- WBR, SD. Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel