[Bug 21923] New: Sort problem in some letters of Patron list
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21923 Bug ID: 21923 Summary: Sort problem in some letters of Patron list Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: normal Priority: P5 - low Component: Patrons Assignee: koha-bugs@lists.koha-community.org Reporter: kohadevinim@devinim.com.tr QA Contact: testopia@bugs.koha-community.org CC: gmcharlt@gmail.com, kyle.m.hall@gmail.com 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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21923 --- Comment #1 from Devinim <kohadevinim@devinim.com.tr> --- Small typo correction Ç,İ,Ö,Ü should come after C,I,O,U. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21923 Devinim <kohadevinim@devinim.com.tr> changed: What |Removed |Added ---------------------------------------------------------------------------- See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=21778 -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21923 paxed <pasi.kallinen@joensuu.fi> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |pasi.kallinen@joensuu.fi See Also| |https://bugs.koha-community | |.org/bugzilla3/show_bug.cgi | |?id=20269 --- Comment #2 from paxed <pasi.kallinen@joensuu.fi> --- (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; -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21923 Josef Moravec <josef.moravec@gmail.com> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |josef.moravec@gmail.com -- You are receiving this mail because: You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21923 Jonathan Druart <jonathan.druart@bugs.koha-community.org> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |jonathan.druart@bugs.koha-c | |ommunity.org --- Comment #3 from Jonathan Druart <jonathan.druart@bugs.koha-community.org> --- As Pasi said it is expected and I would not consider it a bug. -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21923 --- Comment #4 from paxed <pasi.kallinen@joensuu.fi> --- (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 -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21923 --- Comment #5 from Devinim <kohadevinim@devinim.com.tr> --- (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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21923 --- Comment #6 from paxed <pasi.kallinen@joensuu.fi> --- (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. -- You are receiving this mail because: You are watching all bug changes. You are the assignee for the bug.
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21923 Katrin Fischer <katrin.fischer@bsz-bw.de> changed: What |Removed |Added ---------------------------------------------------------------------------- Resolution|--- |DUPLICATE Status|NEW |RESOLVED --- Comment #7 from Katrin Fischer <katrin.fischer@bsz-bw.de> --- *** This bug has been marked as a duplicate of bug 20269 *** -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.
participants (1)
-
bugzilla-daemon＠bugs.koha-community.org