[OSM-dev] API 0.6 Bugs
tom at compton.nu
Thu Dec 4 12:32:52 GMT 2008
Shaun McDonald wrote:
> Actually as MySQL is case-insensitive for unique indexes, the tags are
> case-insensitive, so you can't have a changeset/node/way/relation with
> the tags NOTE and note.
> If we move to postgres, which uses case-sensitive unique indexes, then
> the keys will become case-sensitive.
You can make then case sensitive in MySQL if you want - just give the
field a case sensitive collation sequence. The only reason MySQL is case
insensitive by default is the default collation sequence is case
Tom Hughes (tom at compton.nu)
More information about the dev