[Koha] koha sorting issues

[MJ Ray]

Haik Zargaryan wrote:
> I have previously written to the list about our issues with sorting search results in our non-latin character catalog. I have been advised to modify the sort-string-utf.chr file but it did not work. Now i am trying to achieve this by converting the character set and collation of the MySQL tables. We have converted the collation of the table biblio, deleted the zebra index and re-indexed it, but still the non-latin character search results are sorted incorrectly, when I sort them for example by title. Could you please advise me which specific table should be altered? In what table is the MARC information stored? Of course, any other advice to solve the sorting issue is also welcomed.

As a minimum, I think you must convert biblioitems and items too, plus
any other tables with those in their names (deletedbiblioitems?), plus
any others which are involved with them, including import_records.

It's probably simpler and safer to convert all the tables if you can.

Hope that explains,
-- 
MJ Ray (slef), member of www.software.coop, a for-more-than-profit co-op
http://koha-community.org supporter, web and library systems developer.
In My Opinion Only: see http://mjr.towers.org.uk/email.html
Available for hire (including development) at http://www.software.coop/