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
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html