[gdal-dev] ogr2ogr encoding

[Alexandre Dube]

Hi,

  I need to add a dbf file to a postgis database.  I use ogr2ogr with 
the postgresql driver for that.  Problem is, I get an encoding error :

=== ERROR START ===
Warning 1: PQescapeString(): incomplete multibyte character

  input: 'Río'
    got: 'Río '

ERROR 1: INSERT command for new feature failed.
ERROR:  invalid byte sequence for encoding "UTF8": 0xed6f20
HINT:  This error can also happen if the byte sequence does not match 
the encoding expected by the server, which is controlled by 
"client_encoding".
=== ERROR END ===

  I tried to set the database encoding of my database with \encoding or 
SET CLIENT_ENCODING TO 'encoding'; but it's not working.  I tried latin1 
and UTF8.  What am I missing ?

-- 
Alexandre Dubé
Mapgears
www.mapgears.com