Howto read a UTF-8 CSV with COPY?

Поиск
Список
Период
Сортировка
От Andreas
Тема Howto read a UTF-8 CSV with COPY?
Дата
Msg-id 4CDC67CD.30004@gmx.net
обсуждение исходный текст
Ответы Re: Howto read a UTF-8 CSV with COPY?  (LazyTrek <lazytrek@gmail.com>)
Список pgsql-novice
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.

Is there a way to import UTF8 encoded csv files ?

В списке pgsql-novice по дате отправления:

Предыдущее
От: Bastiaan Olij
Дата:
Сообщение: Interesting install issues on Windows 2003 domain server
Следующее
От: LazyTrek
Дата:
Сообщение: Re: Howto read a UTF-8 CSV with COPY?