IMCDb Forum
General » Š in Skoda
Category:  
« Previous topic
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Š in Skoda
Published 11/02/2007 @ 01:33:05, By wickey
It is nice, that we finally have Skoda as Škoda, but those cars should be in the alphabetical order behind S and before T, not at the end.. Is it possible to fix it?
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Š in Skoda
Published 11/02/2007 @ 11:46:58, By antp
I forgot why I stored them as "Skoda" in the database and modified the text only for display, so I changed that... but now you remind me that problem :grin:
There is the same with ÖAF actually (and all the non-French accents, though it is less visible in the middle of a word).
I'll fix that by restoring the trick that I was using before; even if it is not a very smart way to manage these names, I guess that there is no better choice until the version of MySql is upgraded.

Latest Edition: 11/02/2007 @ 11:47:52
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Š in Skoda
Published 11/02/2007 @ 11:59:40, By wickey
thanks :smile:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Š in Skoda
Published 11/02/2007 @ 12:37:47, By antp
Hmmm actually it seems that we could migrate the database to MySQL 5 (currently it is v4) but for that I have to recreate the database (i.e. I will have to copy all the data to the new database), so I'll have to close the site for that operation.
I'll do some tests and probably make that change on friday or saturday. It will also solve searches on special characters (e.g. currently if you search on "Zundapp" it does not find "Zündapp").
For Skoda it works only because I added a replacement of the name when it is written without the inversed ^

Latest Edition: 11/02/2007 @ 12:38:14
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Š in Skoda
Published 11/02/2007 @ 14:17:30, By antp
I tested it locally: if it works fine for ÖAF, it still fails for Skoda. I wonder why this "Š" seems accepted under windows but not by the server. I guess that it is not part of the latin1 charset, but part of the windows-1252 charset... and I cannot switch the database to this Windows chaset. So I restored the "trick" that I used previously for Skoda, and I will still move to mysql5 to have ÖAF working correctly "automatically".
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Š in Skoda
Published 11/02/2007 @ 14:34:06, By wickey
nice, now in english please :lol: - just kidding - what will we do without you antp?!
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Š in Skoda
Published 11/02/2007 @ 15:20:54, By antp
:grin: well, I do not know what knowledge have the various members in programming and IT stuff.
Anyway it is not very important, the only thing to know is that accents that do not exist in west-european languages should not be used, except if I add a special thing for a name that uses it (like Skoda and Skoda-Liaz).
And for the sorting problem of German ö/ü/ä, we will have to wait that I change the database server.
That change will maybe also allow me to add some interesting search features, like a link that could display all comments from pages where you posted at least one comment: could be useful for those that want to check if someone replied to them without having to check all the pages where they posted.
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Š in Skoda
Published 11/02/2007 @ 18:56:28, By wickey
yes, that will be interesting - maybe also marking of pictures we want some members to see - I mean I add some unknown Rolls Royce and want Juergen not to miss it - should be a way to give him a notice?
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Š in Skoda
Published 11/02/2007 @ 19:33:21, By antp
I could add something like that, but it would be much more complex. It would be close to private message system actually.
Well, it is one of the many things that I have to add :grin:
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Š in Skoda
Published 28/03/2007 @ 16:29:07, By atom
Wouldn't it be easier if you add "Mark this box if you want to be notified when a new ________ is added to the site"
Direct link to this message Edit  Quote  Add this message as quote for multiple quotes  Delete  Top  Bottom
Š in Skoda
Published 28/03/2007 @ 17:00:03, By antp
That could be an idea, though that you should also be notified when a car is renamed: e.g. when it is added as "unknown" and that later it is set to "rolls-royce unknown", to take Wikey's example.
Add Reply - Category:  
Sign In :: Sign Up :: Lost your login or your password?
KelCommunity.be :: © 2004-2024 Akretio SPRL :: Powered by Kelare