Postgres Pro
Downloads
Home   >   mailing lists

Character conversion... - Mailing list pgsql-general

From FC
Subject Character conversion...
Date
Msg-id 951C2B13-A59A-4D79-8929-9EBFEADD1FDD@myamail.com
Whole thread Raw
In response to Re: SQL question.  ("Jim Buttafuoco" <jim@contactbda.com>)
List pgsql-general
Tree view 
I have all my database encoded in ISO-8859-1 and I would like to
convert this database in UNICODE.

I have try this but with no success.

pg_dump dbase > foo.db
createdb -E UNICODE dbase
psql dbase < foo.db

I have also try to modify the value of client_encoding in the foo.db
file but that didn't fix my problem.

Thanks.
Fred

pgsql-general by date:

Previous
From: Eric D Nielsen
Date:
Subject: Re: Advice on merging two primary keys...
Next
From: "Zlatko Matic"
Date:
Subject: Re: how to use pg_dump and then restored onto development server