Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Re: [NOVICE] Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
Date
Msg-id 15735.1360259475@sss.pgh.pa.us
Whole thread Raw
In response to Re: [NOVICE] Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1  (Zach Seaman <znseaman@gmail.com>)
Responses Re: [NOVICE] Re: [NOVICE] Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
List pgsql-novice
Tree view 
Zach Seaman <znseaman@gmail.com> writes:
> I changed from LATIN1, set my database to UTF8, and my client_encoding is
> UTF8.

> ERROR:  invalid byte sequence for encoding "UTF8": 0xe17320
> �s[space]

No, the client encoding needs to be LATIN1 to read this file.

            regards, tom lane

pgsql-novice by date:

Previous
From: Zach Seaman
Date:
Subject: Re: [NOVICE] Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
Next
From: Nipuna
Date:
Subject: Finding the no of files and directories in a path