Change database encoding - Mailing list pgsql-novice

From Keith Worthington
Subject Change database encoding
Date
Msg-id 20060328145856.M29932@narrowpathinc.com
Whole thread Raw
Responses Re: Change database encoding  ("Shoaib Mir" <shoaibmir@gmail.com>)
List pgsql-novice
Hi All,

When I originally built a database I did not understand the ramifications of
choosing the encoding.  Not knowing any better I chose SQL-ASCII.  Since
upgrading pgadmin3 to the latest release I am cautioned that I should switch to
UNICODE.

How do I go about changing the database encoding?

Is UNICODE the 'best' choice for a general purpose database?

TIA

Kind Regards,
Keith

pgsql-novice by date:

Previous
From: "Guido Barosio"
Date:
Subject: Re: Transfer from MySQL to PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: LIMIT clause and long timings