Jeff McKenna gatewaygeomatics.com> writes:
>
> On 12-06-13 10:46 AM, Jukka Rahkonen wrote:
> >
> > Next trouble: I would now take the data back from PostGIS into Spatialite
> > (it
> > was much faster to do some processing with PostGIS) but the happens again:
> > my
> > non-ascii characters a
Le mercredi 13 juin 2012 12:57:11 Jukka Rahkonen a écrit :
> Jeff McKenna gatewaygeomatics.com> writes:
> > Hmm I have had to use the magical "-W" switch before with shp2pgsql to
> > specify encoding; I wonder if with ogr2ogr you should pass a "-sql"
> > switch with something like "SET CLIENT_ENCO
On 12-06-13 10:46 AM, Jukka Rahkonen wrote:
>
> Next trouble: I would now take the data back from PostGIS into Spatialite (it
> was much faster to do some processing with PostGIS) but the happens again: my
> non-ascii characters are converted to something invalid. I cannot see any
> SQLITECLIENTEN
Jukka Rahkonen mmmtike.fi> writes:
>
> Jeff McKenna gatewaygeomatics.com> writes:
>
>
> > Hmm I have had to use the magical "-W" switch before with shp2pgsql to
> > specify encoding; I wonder if with ogr2ogr you should pass a "-sql"
> > switch with something like "SET CLIENT_ENCODING to UTF8
On 12-06-13 9:57 AM, Jukka Rahkonen wrote:
>
> It reads actually in the documentation http://gdal.org/ogr/drv_pg.html
> Giving SET PGCLIENTENCODING=LATIN1 before running ogr2ogr helped. I had tried
> first something that I read from the internet by giving
> --config PGCLIENTENCODING LATIN1 but it
Jeff McKenna gatewaygeomatics.com> writes:
> Hmm I have had to use the magical "-W" switch before with shp2pgsql to
> specify encoding; I wonder if with ogr2ogr you should pass a "-sql"
> switch with something like "SET CLIENT_ENCODING to UTF8" ? But I
> haven't tested that.
It reads actually
On 12-06-13 8:58 AM, Jukka Rahkonen wrote:
> Hi,
>
> How could I prevent the following problem:
>
> ERROR 1: INSERT command for new feature failed.
> ERROR: invalid byte sequence for encoding "UTF8": 0xc56b
>
> Command: INSERT INTO "test_table" ("wkb_geometry" , "address",
> "osoite") VALUES ('
Hi,
How could I prevent the following problem:
ERROR 1: INSERT command for new feature failed.
ERROR: invalid byte sequence for encoding "UTF8": 0xc56b
Command: INSERT INTO "test_table" ("wkb_geometry" , "address",
"osoite") VALUES ('010120FB0BAB1109023B190841634688040C595941'
::GEOMETR