Message-ID: <54D7CAC4.2010509@aklaver.com>
Date: Sun, 08 Feb 2015 12:44:52 -0800
From: Adrian Klaver <adrian.klaver@aklaver.com>
User-Agent: Mozilla/5.0 (X11; Linux i686;
 rv:31.0) Gecko/20100101 Thunderbird/31.4.0
MIME-Version: 1.0
To: Oliver <ofabelo@gmail.com>,
 Forums postgresql <pgsql-general@postgresql.org>,
 "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org>
Subject: Re: [GENERAL] Change postgresql encoding
References: 
 <CALQkqm9fW4Y9SrnDu+TsMd-5eazqwZYLCCy23z33nCwNXQFzJQ@mail.gmail.com>
In-Reply-To: 
 <CALQkqm9fW4Y9SrnDu+TsMd-5eazqwZYLCCy23z33nCwNXQFzJQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

On 02/08/2015 11:20 AM, Oliver wrote:
> Hi,
> I have a new postgresql installation done, it has utf-8 encoding.
> I have to make a Oracle database migration and it has ISO8859-15
> encoding, should I change postgresql encoding to same Oracle encoding or
> with utf-8 it should go well?
> If I want change postgresql encoding, I have understood that I should
> reinstall postgresql (I do installation from rpm official binary files
> for red hat), someone knows say me if when you install software it asks
> you for choosing encoding or it puts it from what you have in the
> system? (I did installation from many time ago and I don't remember it).
> Thanks beforehand.

What version of Postgres?

What version of RedHat?
>
> P.D.: I've tried change encoding to a new postgresql database to latin9,
> but it gives me error for having utf-8.

What was the command you gave?

What was the exact error message?

>
> Regards...


-- 
Adrian Klaver
adrian.klaver@aklaver.com


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin