Bulk insert invalid byte sequence for encoding "UTF8"

omniscale / imposm3

Imposm imports OpenStreetMap data into PostGIS

http://imposm.org/docs/imposm3/latest/

Apache License 2.0

710 stars 156 forks source link

Bulk insert invalid byte sequence for encoding "UTF8" #222

Open mnameghi opened 4 years ago

mnameghi commented 4 years ago

Hi I had an issue with planet data. There was an error when bulk insert:

[2019-12-28T23:48:36+03:30] 7:02:17 [fatal] bulk insert into "base_water": SQL Error: pq: invalid byte sequence for encoding "UTF8": 0x00 in query COPY "import"."base_water" ("osm_id", "geometry", "type", "area") FROM STDIN