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