Koha Test Wiki MW Canasta on Koha Portainer

Test major Koha Wiki changes or bug fixes here without fear of breaking the production wiki.

For the current Koha Wiki, visit https://wiki.koha-community.org .

Sorting in Swedish

From Koha Test Wiki MW Canasta on Koha Portainer
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