Re: Trying to understand encoding.

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

Geez. My default terminal didn't support UNICODE. Shame on me :P

Thanks!

Douglas McNaught wrote:
> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2008-02-15 14:31:59 Re: the feasibility of sending email from stored procedure in Postgres
Previous Message Phoenix Kiula 2008-02-15 14:21:16 Pains in upgrading to 8.3