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/ _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
