On 2010-11-11, Andreas <maps(dot)on(at)gmx(dot)net> wrote:
> I'd like to import some data from ms-office that has text columns with
> international characters in it.
> COPY complains about illegal byte sequences.
> When I placed a "set client_encoding = LATIN1" in front of the COPY
> command, COPY was happy.
> It still didn't work as expected. There were empty attributes in the
> imported table when there were accent decorated characters in the source
latin-1 was probably the wrong client encoding unless it was office on
a really old Mac.
> Is there a way to import UTF8 encoded csv files ?
but the files must be utf8, close is noy good enough.
what sequence is it complaining about?
⚂⚃ 100% natural
In response to
pgsql-novice by date
|Next:||From: Jasen Betts||Date: 2010-11-15 18:18:38|
|Subject: Re: login error - Warning: pg_connect(): Unable to connect to
PostgreSQL server: FATAL: password authentication failed for user "kamik"|
|Previous:||From: peter||Date: 2010-11-15 14:47:01|
|Subject: Re: Could not open relation with OID (table