[osmosis-dev] Two tag keys with different capitalisation

Anthony osm at inbox.org
Tue Dec 1 17:20:58 GMT 2009


On Tue, Dec 1, 2009 at 12:17 PM, Marcus Wolschon
<marcus.wolschon at googlemail.com> wrote:
> How is that a problem for MySQL?
> "h" and "H" have different binary representations and are
> thus different keys, are they now?

By default MySQL treats all comparisons on varchars as case insensitive.

The alternative is to use varchar binary to treat comparisons as case
sensitive, but this has the side-effect of sorting based on binary
value.




More information about the osmosis-dev mailing list