Postgres Pro
Downloads
Home   >   mailing lists

Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1 - Mailing list pgsql-novice

From Gurjeet Singh
Subject Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
Date
Msg-id CABwTF4Vxit=oVytbs-=_EHac8AYgxkPYZP=8FAX9eTQ_wV_MaQ@mail.gmail.com
Whole thread Raw
In response to Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1  (Zach Seaman <znseaman@gmail.com>)
List pgsql-novice
Tree view
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 by date:

Previous
From: Zach Seaman
Date:
Subject: Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
Next
From: James David Smith
Date:
Subject: Re: Installation 8.4 > 9.1