Thread: [pg-sql] Character encoding

[pg-sql] Character encoding

From
BenLaKnet
Date:
How is it possible to convert a database in SQL_ASCII to UNICODE ?

Thx a lot


Regards

Ben



Re: [pg-sql] Character encoding

From
Vivien Malerba
Date:
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