Converting a database from LATIN1 to UTF-8 - Mailing list pgsql-general

From Tormod Omholt-Jensen
Subject Converting a database from LATIN1 to UTF-8
Date
Msg-id 4427CD51.4050404@boostcom.no
Whole thread Raw
Responses Re: Converting a database from LATIN1 to UTF-8
Re: Converting a database from LATIN1 to UTF-8
List pgsql-general
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

pgsql-general by date:

Previous
From: Paolo Sala
Date:
Subject: Inheritance
Next
From: Martijn van Oosterhout
Date:
Subject: Re: case insensitive match in unicode