Skip site navigation (1) Skip section navigation (2)

Change database encoding

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Change database encoding
Date: 2006-03-28 15:04:28
Message-ID: 20060328145856.M29932@narrowpathinc.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2006-03-28 15:51:26
Subject: Re: LIMIT clause and long timings
Previous:From: Guido BarosioDate: 2006-03-28 12:22:39
Subject: Re: Transfer from MySQL to PostgreSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group