X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [64.117.224.130])
	by svr1.postgresql.org (Postfix) with ESMTP id B544AD1B50E
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Sep 2003 09:20:23 +0000 (GMT)
Received: from svr1.postgresql.org ([64.117.224.193])
	by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new,
	port 10024) with ESMTP id 72990-03
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Fri, 26 Sep 2003 06:19:53 -0300 (ADT)
Received: from relais1.stna.aviation-civile.gouv.fr
	(relais1.stna.aviation-civile.gouv.fr [143.196.161.40])
	by svr1.postgresql.org (Postfix) with ESMTP id 6FD80D1B507
	for <pgsql-sql@postgresql.org>; Fri, 26 Sep 2003 06:19:50 -0300 (ADT)
Received: by relais1.stna.aviation-civile.gouv.fr (MTA server DGAC - STNA,
	from userid 0) id 60FCA6F242; Fri, 26 Sep 2003 11:18:09 +0200 (CEST)
Received: from cranberries.stna.dgac.fr (localhost.localdomain [127.0.0.1])
	by relais1.stna.aviation-civile.gouv.fr (MTA server DGAC - STNA) with
	ESMTP id 19C8577136; Fri, 26 Sep 2003 11:18:09 +0200 (CEST)
Received: from dalet ([143.196.31.67])
	by coors.stna.dgac.fr (Lotus Domino Release 5.0.10)
	with ESMTP id 2003092611200221:20032 ;
	Fri, 26 Sep 2003 11:20:02 +0200
Subject: Re: [pg-sql] Character encoding
From: Vivien Malerba <vivien.malerba@aviation-civile.gouv.fr>
To: BenLaKnet <benlaknet@icqmail.com>
Cc: pgsql-sql <pgsql-sql@postgresql.org>
In-Reply-To: <3F7307C5.7000400@icqmail.com>
References: <3F7307C5.7000400@icqmail.com>
Message-Id: <1064567936.10533.2.camel@dalet.stna.dgac.fr>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.5 
Date: Fri, 26 Sep 2003 11:18:57 +0200
X-MIMETrack: Itemize by SMTP Server on NS-STNA-03/STNA/DGAC(Release 5.0.10
	|March 22, 2002) at 26/09/2003 11:20:02,
	Serialize by Router on CS-SUD/DGAC(Release 5.0.10 |March 22,
	2002) at 26/09/2003 11:20:05,
	Serialize complete at 26/09/2003 11:20:05
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain; charset=iso-8859-15
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Archive-Number: 200309/327
X-Sequence-Number: 15305

Le jeu 25/09/2003 =E0 17:20, BenLaKnet a =E9crit :
> How is it possible to convert a database in SQL_ASCII to UNICODE ?
>=20
> 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