| From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
|---|---|
| To: | Zach Seaman <znseaman(at)gmail(dot)com> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1 |
| Date: | 2013-02-07 15:03:55 |
| Message-ID: | CAJKUy5iSGapBBHaK-tRSzM+emyFqaB_4hBkeLhaaW89CtSHLWw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-novice |
On Wed, Feb 6, 2013 at 7:56 PM, Zach Seaman <znseaman(at)gmail(dot)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.
>
well, that mail is from 2005... what version of postgres are you running at?
> ERROR: invalid byte sequence for encoding "UTF8": 0xe17371
>
run:
SET client_encoding TO UTF8;
before running the copy command, or maybe set to LATIN1
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
Phone: +593 4 5107566 Cell: +593 987171157
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-02-07 15:04:20 | Re: feature requests (possibly interested in working on this): functional foreign keys |
| Previous Message | Anoop K | 2013-02-07 14:49:22 | Re: REINDEX deadlock - Postgresql -9.1 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ken Benson | 2013-02-07 15:24:14 | Re: Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1 |
| Previous Message | Gavan Schneider | 2013-02-07 12:08:17 | Re: [NOVICE] Pro blems with ñ and tildes / CSV import problems in PostgreSQL 9.1 |