Обсуждение: [pg-sql] Character encoding

Поиск
Список
Период
Сортировка

[pg-sql] Character encoding

От
BenLaKnet
Дата:
How is it possible to convert a database in SQL_ASCII to UNICODE ?

Thx a lot


Regards

Ben



Re: [pg-sql] Character encoding

От
Vivien Malerba
Дата:
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