{"action":"created","issue":{"url":"https://api.github.com/repos/mapzen/vector-datasource/issues/577","repository_url":"https://api.github.com/repos/mapzen/vector-datasource","labels_url":"https://api.github.com/repos/mapzen/vector-datasource/issues/577/labels{/name}","comments_url":"https://api.github.com/repos/mapzen/vector-datasource/issues/577/comments","events_url":"https://api.github.com/repos/mapzen/vector-datasource/issues/577/events","html_url":"https://github.com/mapzen/vector-datasource/issues/577","id":139210663,"number":577,"title":"Error while loading 10m_populated_places because of data value","user":{"login":"batje","id":547014,"avatar_url":"https://avatars.githubusercontent.com/u/547014?v=3","gravatar_id":"","url":"https://api.github.com/users/batje","html_url":"https://github.com/batje","followers_url":"https://api.github.com/users/batje/followers","following_url":"https://api.github.com/users/batje/following{/other_user}","gists_url":"https://api.github.com/users/batje/gists{/gist_id}","starred_url":"https://api.github.com/users/batje/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/batje/subscriptions","organizations_url":"https://api.github.com/users/batje/orgs","repos_url":"https://api.github.com/users/batje/repos","events_url":"https://api.github.com/users/batje/events{/privacy}","received_events_url":"https://api.github.com/users/batje/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-03-08T08:24:50Z","updated_at":"2016-03-08T11:07:14Z","closed_at":null,"body":"* **What did you see?**\r\n\r\nWhile loading ne_10m_populated_places:\r\n\r\n`\r\n\r\n> addgeometrycolumn\r\n>\r\n> public.ne_10m_populated_places.the_geom SRID:900913 TYPE:POINT DIMS:2 \r\n>(1 row)\r\n>\r\n>ERROR:  value too long for type character varying(41)\r\n>CONTEXT:  COPY ne_10m_populated_places, line 4855, column ls_name: \"Amundsen‰ÛÒScott South Pole Station (USA)\"\r\n>ERROR:  current transaction is aborted, commands ignored until end of transaction block\r\n>ROLLBACK`\r\n\r\n* **What did you expect to see?**\r\n\r\nSuccess!\r\n\r\n* **How did I solve it?**\r\n\r\n`shp2pgsql -dIe -s 900913 -W Windows-1252 -g the_geom  ne_10m_populated_places-merc.shp ne_10m_populated_places | psql -U osm -d mydb `\r\n\r\nIs a bit ugly, but it works.\r\n"},"comment":{"url":"https://api.github.com/repos/mapzen/vector-datasource/issues/comments/193730943","html_url":"https://github.com/mapzen/vector-datasource/issues/577#issuecomment-193730943","issue_url":"https://api.github.com/repos/mapzen/vector-datasource/issues/577","id":193730943,"user":{"login":"zerebubuth","id":271360,"avatar_url":"https://avatars.githubusercontent.com/u/271360?v=3","gravatar_id":"","url":"https://api.github.com/users/zerebubuth","html_url":"https://github.com/zerebubuth","followers_url":"https://api.github.com/users/zerebubuth/followers","following_url":"https://api.github.com/users/zerebubuth/following{/other_user}","gists_url":"https://api.github.com/users/zerebubuth/gists{/gist_id}","starred_url":"https://api.github.com/users/zerebubuth/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/zerebubuth/subscriptions","organizations_url":"https://api.github.com/users/zerebubuth/orgs","repos_url":"https://api.github.com/users/zerebubuth/repos","events_url":"https://api.github.com/users/zerebubuth/events{/privacy}","received_events_url":"https://api.github.com/users/zerebubuth/received_events","type":"User","site_admin":false},"created_at":"2016-03-08T11:07:14Z","updated_at":"2016-03-08T11:07:14Z","body":"Thanks for reporting this! Looks like the encoding got messed up somewhere along the way. To give us a better chance of reproducing this, could you tell us what the encoding of your database is, please? You can see it by running:\r\n\r\n```bash\r\npsql -c \"select pg_encoding_to_char(encoding) from pg_database where datname='mydb'\" postgres\r\n```\r\n\r\nStrangely, in my database the encoding still looks wrong, but the length is reported as 41:\r\n\r\n```\r\nmapzen=# select ls_name from ne_10m_populated_places where ls_name like 'Amundsen%';\r\n                  ls_name                  \r\n-------------------------------------------\r\n Amundsen‰ÛÒScott South Pole Station (USA)\r\n(1 row)\r\n\r\nmapzen=# select length(ls_name) from ne_10m_populated_places where ls_name like 'Amundsen%';\r\n length \r\n--------\r\n     41\r\n(1 row)\r\n```\r\n\r\n@nvkelso - I notice this is the `-merc` shape. Is it possible that either one leg or the other of the load/dump was done without `-W Windows-1252` when it was transformed?"}}