Postgres Pro
Downloads
Home   >   mailing lists

convert from latin1 to utf8 - Mailing list pgsql-admin

From Marc Fromm
Subject convert from latin1 to utf8
Date
Msg-id 93361C67E4EE844A80935863A4FF4B6C076EED0C@Exch2010MB-2.univ.dir.wwu.edu
Whole thread Raw
List pgsql-admin
Tree view

I need to convert a bunch of my databases to utf8 before I can migrate them to postgresql 8.4. Is there a command that during the pg_dumpall process the encoding can be changed from latin1 to utf8?

 

This is the error I get when migrating the databases from 8.1 to a machine running 8.4

psql:pgdbs:215: ERROR:  encoding LATIN1 does not match locale en_US.UTF-8

DETAIL:  The chosen LC_CTYPE setting requires encoding UTF8.

 

Thanks

pgsql-admin by date:

Previous
From: Marc Fromm
Date:
Subject: Re: move dbs from 8.1 to 8.4
Next
From: Scott Whitney
Date:
Subject: Re: convert from latin1 to utf8