Author | Message |
---|---|
◊ 2007-04-11 17:28 |
Antp ![]() -- Last edit: 2007-04-11 17:29:17 |
◊ 2007-04-11 20:32 |
Antoine, while you are at it, could you also look at the sorting routine in the makes list. ÖAF is still at the end, and now the Ż... would move there, too. Same problem with - Büssing and Büssing-N.A.G. sorted after BUT -- others with umlauts: Hägglund, Kässbohrer, Kässbohrer Setra, ÖAF, Phänomen, Schlüter (no problem here), Škoda (in the list as Skoda), Zündapp (no problem here) - B.E.F. standing before Baboulin -- others with dots: G.V., H.R.G., M.A. (no problem here), N.A.G. (which someone renamed to NAG ![]() - D-RAD standing before DAC (debatable if that is correct or not) -- others with dashes: E-One, E-Z-Go, Vickers-Armstrong (after Vickers Defense) - Du Pont standing before Dual-Ghia (again debatable if that is correct or not) -- others with an early blank: Pars Khodro (no problem here) - O&K standing before Oakland -- others with special symbols: TH!NK, Xi'an It seems to work for Théophile Schneider, Türk Willys This would also help to group makes that changed their writing: Land-Rover / Land Rover, M.A.N / MAN, etc. We could then use the correct writing for the periode. |
◊ 2007-04-11 23:33 |
Ż is not in iso-8859-1 charset so it cannot be stored property, I'll have to do like for Skoda (as Weasel suggested), which is stored without the accent on the S in the database Problems with German accents (¨) will be fixed soon, as I will probably move to MySQL 5 (currently 4). Since these are stored with the accent in the database, but sorted like French textes, they are not properly sorted. For sorting with spaces, dashes and special symbols, I cannot do anything, it depends on how that is handled by MySQL, I suppose that the dash is not seen the same way as a space ![]() For Land-Rover and MAN, I can make it display differently depending of the year (if specified), you just have to give me the rules for these special cases ![]() -- Last edit: 2007-04-11 23:33:48 |
◊ 2007-04-12 00:58 |
It seems they are sorted by their position in the ASCII charset. An option would either be to programme some code to sort the entries different (cannot say if the database allows that), or to have an invisible field which is sorted and in which a sortable name without dashes, dots and funny symbols is stored. Both would mean a bit of extra work for you ... probably 'bit' with a capital 'B'! ![]() I will start to compile a list for you. I will collect all the names and dates first, so that you only have to do the changes once ... hopefully! ![]() It might be a good idea to post this list in the forum first so that all our experts can have a look. -- Last edit: 2007-04-12 00:59:28 |
◊ 2007-04-12 10:15 |
For sorting, I believe that some options exist depending on the database system used, but I doubt that I can do much with what is available here. Anyway maybe it will work better with v5, I'll do the test this evening or tomorrow. |