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/
>
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 |