Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgreSQL and character set change - Mailing list pgsql-general

From Albe Laurenz
Subject Re: PostgreSQL and character set change
Date
Msg-id D960CB61B694CF459DCFB4B0128514C2039380ED@exadv11.host.magwien.gv.at
Whole thread Raw
In response to PostgreSQL and character set change  (Jayadevan M <Jayadevan.Maymala@ibsplc.com>)
Responses Re: PostgreSQL and character set change  (Jayadevan M <Jayadevan.Maymala@ibsplc.com>)
List pgsql-general
Tree view 
Jayadevan M wrote:
> We have a PostgreSQL server with ASCII data.  We have a
> requirement for the db to support UTF also. Which is the best
> approach -
> 1) Make a new installation, move data

This is the only and hence the best approach.
It doesn't have to be a new installation, a new database with
encoding UTF8 is enough.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: PostgreSQL and character set change
Next
From: "Albe Laurenz"
Date:
Subject: Re: Error starting backup