pg_dumpall and convert from LATIN1 to UTF-8?

#1

Hi Everyone,

I have used pg_dumpall on a database that was created with LATIN1
encoding and has a whole bunch of messy latin1 data in it.

I want to restore this data to a new db with UTF-8 encoding, with the
data converted so the 8859-1 characters display properly.

How should I go about doing this?

Thanks,

Joseph

#2

hi,

Joseph wrote:

Quote:

Hi Everyone,

I have used pg_dumpall on a database that was created with LATIN1
encoding and has a whole bunch of messy latin1 data in it.

I want to restore this data to a new db with UTF-8 encoding, with the
data converted so the 8859-1 characters display properly.

How should I go about doing this?

try function convert (and check CREATE CONVERSION)

c.

#3

On Срд, 2004-02-25 at 06:29 -0800, Joseph wrote:

Quote:

Hi Everyone,

I have used pg_dumpall on a database that was created with LATIN1
encoding and has a whole bunch of messy latin1 data in it.

I want to restore this data to a new db with UTF-8 encoding, with the
data converted so the 8859-1 characters display properly.

How should I go about doing this?

Pipe the dump through iconv.

--
Markus Bertheau <twanger (AT) bluetwanger (DOT) de>

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

pg_dumpall and convert from LATIN1 to UTF-8?

comp.databases.postgresql.novice comp.databases.postgresql.novice

pg_dumpall and convert from LATIN1 to UTF-8? - 02-25-2004 , 08:29 AM

Re: pg_dumpall and convert from LATIN1 to UTF-8? - 02-27-2004 , 04:39 AM

Re: pg_dumpall and convert from LATIN1 to UTF-8? - 02-29-2004 , 03:50 AM