Sorting in Swedish
Jump to navigation
Jump to search
When you browse Swedish patrons in Koha, you will notice that out of the box the sorting is wrong, for example names beginning with A and Ä are sorted together. To fix this you need to update the "collation" of the borrowers.surname field in the database. Log into MySQL/MariaDB and issue the following command:
ALTER TABLE borrowers MODIFY surname LONGTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_swedish_ci;
See also
- Bug 20269 - Allow selecting default collate rule