problem with importing dbf file into postgresql using navicat on mac OS X - Mailing list pgsql-general

From Mathias Ghys
Subject problem with importing dbf file into postgresql using navicat on mac OS X
Date
Msg-id 13D4CE9B-D2FF-4722-8873-4CE14801A794@telenet.be
Whole thread Raw
Responses Re: problem with importing dbf file into postgresql using navicat on mac OS X  (John DeSoi <desoi@pgedit.com>)
List pgsql-general
Hi everyone,

I bought a dvd containing all the roads and positions of houses in
Belgium. Now it already worked to import all the gml files into my
postgresql database. But the easier import  of dbf files always turns
out wrong.

I use navicat on a mac OS X system. I always get the following error
message:

Error Message: ERROR:  invalid byte sequence for encoding "UTF8":
0xe96f70
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".

My postgresql database is UTF-8 encoded. With importing I get the
following data:

http://server58.dedicatedusa.com/~mathias/mathias/datatypes.tiff

do you guys have any idea what i've been doing wrong and how I could
get the *.dbf files into my postgresql database?

many thanks already

Mathias Ghys

pgsql-general by date:

Previous
From: Jens Wilke
Date:
Subject: Question on warm standby log shipping
Next
From: "Elizabeth George"
Date:
Subject: help