Postgres Pro
Downloads
Home   >   mailing lists

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  (Martijn van Oosterhout <kleptog@svana.org>)
Re: Converting a database from LATIN1 to UTF-8  (Kai Hessing <kai.hessing@hobsons.de>)
List pgsql-general
Tree view 
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