[Koha-bugs] [Bug 21923] Sort problem in some letters of Patron list

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21923

paxed <pasi.kallinen at joensuu.fi> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |pasi.kallinen at joensuu.fi
           See Also|                            |https://bugs.koha-community
                   |                            |.org/bugzilla3/show_bug.cgi
                   |                            |?id=20269

--- Comment #2 from paxed <pasi.kallinen at 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.