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

From Gavan Schneider
Subject Re: [NOVICE] Problems with ñ and tildes / CSV import problems in PostgreSQL 9.1
Date
Msg-id 12876-1360238905-374533@sneakemail.com
Whole thread Raw
List pgsql-general
On Wednesday, February 6, 2013 at 11:56,
2jt6w5k7mt@sneakemail.com (Zach Seaman znseaman-at-gmail.com
|pg-gts/Basic|) wrote:

>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.
>
I may have missed something here... why would anyone suggest
LATIN-1 in modern times?

UTF-8 will do all of LATIN-1 and everything else as well. Except
for legacy support why would anyone use anything other than
UTF-8? (Of course there are those where UTF-16 is a better
choice for their dominant language use, e.g. chinese.)

Suggest you use UTF-8 database encoding and if there are no
problems importing the .csv stay with UTF-8. OTOH if there are
still problems when using UTF-8, stay with UTF-8 while you work
out what it is in the .csv file that's causing the problem.

Regards
Gavan




pgsql-general by date:

Previous
From: Geoff Winkless
Date:
Subject: Re: Re: feature requests (possibly interested in working on this): functional foreign keys
Next
From: Magnus Hagander
Date:
Subject: Re: Hot Standby has PANIC: WAL contains references to invalid pages