While applying patch Bug 21778, we've seen that some Turkish characters on Surname yield incorrect sort order. Ç,İ,Ö,U should come after C,I,O,U.
Small typo correction Ç,İ,Ö,Ü should come after C,I,O,U.
(In reply to Devinim from comment #1) > Small typo correction > > Ç,İ,Ö,Ü should come after C,I,O,U. This is because Koha uses the generic utf8 collation, producing wrong results for some languages (eg. finnish and swedish) when sorted. On the database level, change the collation to utf8_turkish_ci or utf8mb4_turkish_ci, for example: ALTER TABLE borrowers MODIFY surname LONGTEXT COLLATE utf8mb4_turkish_ci;
As Pasi said it is expected and I would not consider it a bug.
(In reply to Jonathan Druart from comment #3) > As Pasi said it is expected and I would not consider it a bug. The "actual" bug/feature request is bug 20269
(In reply to paxed from comment #4) > (In reply to Jonathan Druart from comment #3) > > As Pasi said it is expected and I would not consider it a bug. > > The "actual" bug/feature request is bug 20269 We should find a way to solve this issue, changing collation is just a workaround not the exast solution. It doesn't solve the problem in some cases, think that university library uses Koha and accept student around the world from tens of nationalities.
(In reply to Devinim from comment #5) > (In reply to paxed from comment #4) > > (In reply to Jonathan Druart from comment #3) > > > As Pasi said it is expected and I would not consider it a bug. > > > > The "actual" bug/feature request is bug 20269 > > We should find a way to solve this issue, changing collation is just a > workaround not the exast solution. It doesn't solve the problem in some > cases, think that university library uses Koha and accept student around the > world from tens of nationalities. In theory, the "correct" collation could be dynamically added to the db queries depending on the user's language setting. I have no idea if that would add performance overhead to the queries. Going that route, there's also at least the "alphabet" syspref that would have to change depending on the language.
*** This bug has been marked as a duplicate of bug 20269 ***