[GENERAL] Converting a database from LATIN1 to UTF-8

[Tormod Omholt-Jensen]

We are upgrading our systems to handle new languages and therefore we 
need to change the encoding of our postgres database from LATIN1 to UTF-8.

I have pg_dumped the database and imported it into the new UTF-8 base. 
It seems like this worked just fine.

Can anyone confirm that this is the correct way to do it?


--
Tormod Omholt-Jensen
Developer
Boost Communications AS
www.boostcom.no

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend