[osmosis-dev] Two tag keys with different capitalisation

Anthony osm at inbox.org
Tue Dec 1 16:42:17 GMT 2009


On Tue, Dec 1, 2009 at 11:32 AM, Simon Nuttall <simon.nuttall at gmail.com> wrote:
> I have tracked down a duplicate entry problem to two tag keys that
> have the different capitalisation:
>
>  <node id="568478319" version="1" timestamp="2009-11-22T16:29:08Z"
> uid="192124" user="Tony0" changeset="3187836" lat="50.6536544"
> lon="-3.8970201">
>    <tag k="historic" v="archaeological_site"/>
>    <tag k="Historic" v="Ruin"/>
>    <tag k="name" v="Three Boys"/>
>    <tag k="wpt_symbol" v="Dot"/>
>  </node>
>
> How should I fix up the table definition (I'm using MySQL) to skip over this?

See if `k` varchar(255) binary NOT NULL default '' works.




More information about the osmosis-dev mailing list