Re: Change the character encoding of a database

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