Re: [pg-sql] Character encoding - Mailing list 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