Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1

From: Zach Seaman <znseaman(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
Date: 2013-02-07 00:56:29
Message-ID: CACVtUUuELmZ6CLO3U9keEDnh4YFFbEixL5ruPWjWDvoJfKS1gw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-novice

I'm fairly new to PostgreSQL 9.1 but I need it, so here I am.

This a similar question to this
one<http://www.postgresql.org/message-id/4dda42060512140509xe8b130as@mail.gmail.com>,
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.

Thanks again all,

Zach Seaman

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Igor Neyman 2013-02-07 02:47:46 Re: configuring timezone
Previous Message Terence Ferraro 2013-02-06 23:47:19 Re: configuring timezone

Browse pgsql-novice by date

  From Date Subject
Next Message Gurjeet Singh 2013-02-07 03:12:43 Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
Previous Message Andrew Puschak 2013-02-03 16:18:28 Re: warm standby replication safe failover