[Koha] wrong sorting order of results beginning with accented letters (č, š, ř, ž,...)

[Bohdan Šmilauer]

Hi Fabio, 

many thanks for your advice. It helped me. I have investigated  /etc/koha/
zebradb/zebra-authorities.cfg file,the  specific  entry

# Where are the config files located?

profilePath:/etc/koha/zebradb/authorities/etc:/etc/koha/zebradb/etc:/etc/
koha/zebradb/marc_defs/marc21/authorities:/etc/koha/zebradb/lang_defs/en 

It points to /etc/koha/zebradb/lang_defs/en , where is the file sort-string-
utf.chr, which I updated, as you wrote: 

"map ěêèéëÊÈÉË e", etc. I have found that other syntax can be used "map 
eěêèéëÊÈÉË", or "map ěêèéëÊÈÉË(e)", what is correct? Then I ran koha-rebuild
-zebra -a -v -f.

It caused the accented letters are assumed to be all the same "e" and the 
accent is ignored in collation. But grammatically correct is, that the "e" 
precedes "é", "ě",.....   How can I control this succession?  You can see 
the result on http://koha.doxos.eu:8080, Authority search, "Submit" (leave 
the other fields empty) . 

I want to replace in the Koha missing "Browse authors" by the Authority 
search. The number of authors is typically more then one thousand. I noticed
the authors with No. more then 1000, are not sorted, despite I added 
"sortmax 11000" at the end of etc/koha/zebradb/zebra-authorities.cfg file. 
Selecting authors starting with e.g. letter "H" is not simple task, you have
to skip many screens, there is no direct jump to the letter "H" or to page 
e.g. 345.  Have you some experience with this problem? 

Many thanks
Bohdan Smilauer
Librarian of Economic Library
Letenska 15
Prague 1
Czechia
mail: b.smilauer at post.cz
phone +420736120563


---------- Původní zpráva ----------
Od: Fabio Tiana <fabio.tian at gmail.com>
Datum: 20. 1. 2014
Předmět: Re: [Koha] wrong sorting order of results beginning with accented 
letters (č, š, ř, ž,...)

"Hi there!

You can adjust the mapping for sorting purposes in the sort-string-utf.chr
file, here's a common line as example:

map êèéëÊÈÉË e

Make sure to use an encoding-savvy text editor (e.g. vi) and restart Zebra
when you're done.

Hope this helps,
Fabio


2014/1/18 Bohdan Šmilauer <b.smilauer at post.cz>

> Hi to all!
> I'm trying to achieve the correct sorting in the search results in
> Koha 3.12
> installed on Ubuntu 12.04. I followed the instructions on
>
> http://wiki.koha-community.org/wiki/Encoding_and_Character_Sets_in_Koha
> (http://wiki.koha-community.org/wiki/Encoding_and_Character_Sets_in_Koha)
>
>
> Despite this, the sorting of the results of authorities or titles is
> wrong.
> You can see it on http://koha.doxos.eu:8080/(http://koha.doxos.eu:8080/)
> The variable "locale" is set to cs_CZ.UTF-8 and a simple sample sorting
> program written in Perl works correctly.
>
> Does anyone know which programs in Koha control the collation order of
> resullts on Opac and how to fix it? Thank you very much for the advice.
>
>
>
> Bohdan Smilauer
>
>
> Librarian of Economic Library
>
> Letenska 15
>
> Prague 1
>
> Czechia
>
> mail: b.smilauer at post.cz
>
>
> phone +420736120563
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> _______________________________________________
> Koha mailing list http://koha-community.org
> Koha at lists.katipo.co.nz
> http://lists.katipo.co.nz/mailman/listinfo/koha
>
_______________________________________________
Koha mailing list http://koha-community.org
Koha at lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha"