[GENERAL] Trying to understand encoding.

2008-02-15 Thread Tomás Di Doménico
Greetings. I'm currently using 8.3, but I've been coping with this since previous versions. I'm trying to integrate some LATIN1 and some UTF8 DBs into a single UTF8 one. To avoid the Invalid UNICODE character... error, I used iconv to convert the LATIN1 dumps to UTF8. Now I have the data into

Re: [GENERAL] Trying to understand encoding.

2008-02-15 Thread Douglas McNaught
On 2/15/08, Tomás Di Doménico [EMAIL PROTECTED] 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

Re: [GENERAL] Trying to understand encoding.

2008-02-15 Thread Tomás Di Doménico
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 [EMAIL PROTECTED] 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