Skip site navigation (1) Skip section navigation (2)

Converting a database from LATIN1 to UTF-8

From: Tormod Omholt-Jensen <tormod(at)boostcom(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: Converting a database from LATIN1 to UTF-8
Date: 2006-03-27 11:32:33
Message-ID: 4427CD51.4050404@boostcom.no (view raw, whole thread or download thread mbox)
Thread:
Lists: 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

Responses

pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2006-03-27 11:40:37
Subject: Re: case insensitive match in unicode
Previous:From: Paolo SalaDate: 2006-03-27 11:18:37
Subject: Inheritance

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group