Koha Test Wiki Canasta - March 2024

One of a series of test instances for migrating the Koha Wiki MediaWiki database.

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

Sorting in Swedish

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