Re: [pg-sql] Character encoding

From: Vivien Malerba <vivien(dot)malerba(at)aviation-civile(dot)gouv(dot)fr>
To: BenLaKnet <benlaknet(at)icqmail(dot)com>
Cc: pgsql-sql <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [pg-sql] Character encoding
Date: 2003-09-26 09:18:57
Message-ID: 1064567936.10533.2.camel@dalet.stna.dgac.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message The Guardian 2003-09-26 11:13:44 Problems to be solved as soon as possible
Previous Message Kumar 2003-09-26 07:02:29 How to generate object DDL of the database objects