Re: Trying to understand encoding.

On 2/15/08, Tomás Di Doménico <tdidomenico@avature.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