[OSM-dev] API 0.6 Bugs

Tom Hughes 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 mailing list