There seems to be a problem with the alphabetical listing of entries. Somewhy entry starting with an Ä is placed between entries starting with A's and the other dotted characters are misplaced too.

This is the Estonian alphabet (the Finnish alphabet is almost the same):
A, B, C, D, E, F, G, H, I, J, K, L, M, N, O, P, Q, R, S, Š, Z, Ž, T, U, V, W, Õ, Ä, Ö, Ü, X, Y

Maybe it would be a good idea to let the user choose/define the alphabet.

Comments

martig’s picture

I think this is a big issue for anyone who has non-English books in their database. At the moment biblio doesn't know what to do with foreign characters like Ö, Ä, Õ, and Ü, so it stuffs them somewhere under A, O and U.

rjerome’s picture

A quick scan of the MySQL documentation reveals what apears to be a fairly simple fix for this. I'll test it out and keep you updated.

Ron.

rjerome’s picture

So my plan didn't quite work out the way I hoped. According to the MySQL documentation, you should be able to use the COLLATE modifier in the SQL SELECT command to set the sorting to different character sets. Unfortunately, as of yet, I haven't been able to make this work as advertised. I'll keep playing around with it a bit.

Ron.

catdevrandom’s picture

Status: Active » Closed (fixed)