Koha Test Wiki MediaWiki Postgres

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 MediaWiki Postgres

Jump to: navigation, search
Koha > Country specific > Sweden

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
Retrieved from "https://koha-mw-pg-test01.agogme.com/wiki/Sorting_in_Swedish"
Personal tools