Re: [Firebird-test] [FB-Tracker] Commented: (CORE-3738) Charset UTF8 with collate UNICODE: ORDER BY works wrong for polish characters

[Mariusz N. <mn...@am...>]

Thank you very much for your (very quick) answer !!!


I have tried the solution with CREATE COLLATION,
but it does not solve my problem.
(moreover the attribute LOCALE does not work with my
Firebird 2.5.1. I don't know why).

But I am not convinced.
I steel think that something is wrong with collate UNICODE.
The point is that it sorts single character texts properly and
longer texts IN A DIFFERENT WAY. The sorting order should
mainly depend on the first character in a column.
If accented characters follow the non-accented in single character texts,
so why it does not happen when sorting longer texts?

See the example:

ORDER BY gives:
a, ą, ab   (here 'ą' follows 'a', but not 'ab' - it makes no sense...)

I am sure it should be:
a, ab, ą   (because UNICODE collation is accent sensitive)



Best regards
Mariusz Nogala