From: Vivien Malerba <vivien.malerba@aviation-civile.gouv.fr>
To: BenLaKnet <benlaknet@icqmail.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
Subject: Re: [pg-sql] Character encoding
Date: Fri, 26 Sep 2003 11:18:57 +0200
Message-ID: <1064567936.10533.2.camel@dalet.stna.dgac.fr> (raw)
In-Reply-To: <3F7307C5.7000400@icqmail.com>
References: <3F7307C5.7000400@icqmail.com>
Le jeu 25/09/2003 à 17:20, BenLaKnet a écrit :
> How is it possible to convert a database in SQL_ASCII to UNICODE ?
>
> Thx a lot
I did a pg_dump to a file, converted that file to UTF-8 encoding using
iconv, created a new DB using the "-E unicode" option, and imported the
data into that new DB from the converted dump file.
There is maybe a better solution, but this one works.
Vivien
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: vivien.malerba@aviation-civile.gouv.fr, benlaknet@icqmail.com
Subject: Re: [pg-sql] Character encoding
In-Reply-To: <1064567936.10533.2.camel@dalet.stna.dgac.fr>
* 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