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: (view raw, whole thread or download thread mbox)
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
Boost Communications AS


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