[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 
insensitive.

Tom

-- 
Tom Hughes (tom at compton.nu)
http://www.compton.nu/




More information about the dev mailing list