Re: [GENERAL] Latin1 to UTF-8 ?

2007-08-04 Thread Peter Eisentraut
Aarni Ruuhimäki wrote: So, what would be the proper way to convert the dumps to UTF-8 ? Or any other solution ? Any other tool to work with the problem files ? Dump them again but set your client encoding to UTF8. -- Peter Eisentraut http://developer.postgresql.org/~petere/

[GENERAL] Latin1 to UTF-8 ?

2007-08-03 Thread Aarni Ruuhimäki
Hi, I've set up a new CentOs server with PostgreSQL 8.2.4 and initdb'ed it with UTF-8. Ok, and runs fine. I have a problem with encodings, however. And mainly with the russian cyrillic characters. When I testdumped some dbs from the old FC / Pg 8.0.2, all Latin1, I noticed that some of the