[osmosis-dev] Two tag keys with different capitalisation

[Anthony]

On Tue, Dec 1, 2009 at 12:20 PM, Anthony <osm at inbox.org> 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.