From: Jose' Cruanyes <cruanyes@cegroup.it>
To: Ivo Rossacher <rossacher@bluewin.ch>
Cc: pgsql-admin@postgresql.org
Subject: Re: Change the character encoding of a database
Date: Tue, 29 Jun 2004 00:45:28 +0200
Message-ID: <DA147AD0-C954-11D8-8348-0003935B359C@cegroup.it> (raw)
In-Reply-To: <200406282338.25074.rossacher@bluewin.ch>
References: <200406282338.25074.rossacher@bluewin.ch>
On Jun 28, 2004, at 11:38 PM, Ivo Rossacher wrote:
>
> I did try to dump the database by pgdump database > dump.dmp, droped
> the
> database, recreate it with the encoding UNICODE and restore the dump
> by psql
> database < dump.dmp which worked after some small changes (change the
> client
> encoding to UNICODE) in the dump.dmp. Without the changes in the
> dump.dmp
> there was a error message about invalide codes and no import at all.
> With the
> changes there are still some encoding mistakes (wrong signes in the
> strings)
> but the import basically works.
I've solved this changing the encoding of the dump.dmp file from ASCII
to UTF8
Pax et Bonum
# dott. Jose' Cruanyes Aguilar - C.E. Soft srl
# Pzza. Firenze,4 MILANO - XX Settembre 10, CREMONA
# 02,33603122 0372,460602
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: cruanyes@cegroup.it, rossacher@bluewin.ch
Subject: Re: Change the character encoding of a database
In-Reply-To: <DA147AD0-C954-11D8-8348-0003935B359C@cegroup.it>
References: <200406282338.25074.rossacher@bluewin.ch> <DA147AD0-C954-11D8-8348-0003935B359C@cegroup.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox