Re: Howto read a UTF-8 CSV with COPY?

On 2010-11-11, Andreas <maps.on@gmx.net> wrote:
> Hi,
> 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
> file.

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 ?

copy.
but the files must be utf8, close is noy good enough.

what sequence is it complaining about?

--
⚂⚃ 100% natural