On Tue, Dec 1, 2009 at 12:20 PM, Anthony <[email protected]> wrote: > but this has the side-effect of sorting based on binary value.
See http://wiki.openstreetmap.org/index.php?title=Special:ListUsers&offset=Ajw&limit=5 , which is using MySQL (see http://wiki.openstreetmap.org/wiki/Special:Version). "AkMeR" is sorted before "Aka", because Mediawiki uses binary collations. Anyway, for the purposes of OSM, sort order doesn't seem to matter, so using a binary collation is probably the best workaround. Using "KEY" instead of "PRIMARY KEY" would likely have performance issues. _______________________________________________ osmosis-dev mailing list [email protected] http://lists.openstreetmap.org/listinfo/osmosis-dev
