Re: [GENERAL] Change postgresql encoding

2015-02-08 20:44 GMT+00:00 Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>:

> 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?
>

9.3.4

>
> What version of RedHat?

Red Hat Enterprise Linux Server release 6.5

>
>
>> 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?
>

CREATE DATABASE xxx
WITH ENCODING 'LATIN9'
OWNER=xxx
TEMPLATE=template0
LC_COLLATE='es_ES.latin9'
LC_CTYPE='es_ES.latin9'
CONNECTION LIMIT=-1
TABLESPACE=xxx;

>
> What was the exact error message?
>
>
regional configuration name not valid <<es_ES.latin9>>
SQL state: 42809

I've tried es_ES.iso8859-15 and same error.
I'm using pgadmin III 1.18.1 for running querys. When I run "SHOW
client_encoding;" it shows UNICODE.

>
>> Regards...
>>
>
>
Thanks beforehand.

>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>