Re: Trying to understand encoding.

From: "Douglas McNaught" <doug(at)mcnaught(dot)org>
To: Tomás Di Doménico <tdidomenico(at)avature(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Trying to understand encoding.
Date: 2008-02-15 14:05:35
Message-ID: 5ded07e00802150605v917550dh3fbc63b13b3c70bc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2/15/08, Tomás Di Doménico <tdidomenico(at)avature(dot)net> wrote:

> Now I have the data into the UTF8 DB, and using graphical clients
> everything seems to be great. The thing is, when I query the data via
> psql, with \encoding UTF8 I get weird data ("NeuquÃ(c)n" for "Neuquén").
> However, with \encoding LATIN1, everything looks fine.

Maybe your terminal program doesn't support UTF8, or it's
misconfigured? If you create a UTF8-encoded file and 'cat' it, is the
output correct?

-Doug

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Douglas McNaught 2008-02-15 14:07:37 Re: Are indexes blown?
Previous Message Harald Fuchs 2008-02-15 13:56:50 Re: Are indexes blown?