Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1

Поиск
Список
Период
Сортировка
От Gurjeet Singh
Тема Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
Дата
Msg-id CABwTF4Vxit=oVytbs-=_EHac8AYgxkPYZP=8FAX9eTQ_wV_MaQ@mail.gmail.com
обсуждение исходный текст
Ответ на Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1  (Zach Seaman <znseaman@gmail.com>)
Список pgsql-novice
Дерево обсуждения
On Wed, Feb 6, 2013 at 7:56 PM, Zach Seaman <znseaman@gmail.com> wrote:
I'm fairly new to PostgreSQL 9.1 but I need it, so here I am.

This a similar question to this one, so I have encoded a database with LATIN-1 as suggested but can't copy a CSV file into a table within the database.

ERROR: invalid byte sequence for encoding "UTF8": 0xe17371

Googling doesn't get me anywhere and I am working with Spanish characters.

I think the data in your CSV file should match the client_encoding parameter.

What is your client_encoding parameter set to?

show client_encoding;

--
Gurjeet Singh

http://gurjeet.singh.im/

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

Предыдущее
От: Zach Seaman
Дата:
Сообщение: Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
Следующее
От: James David Smith
Дата:
Сообщение: Re: Installation 8.4 > 9.1