Re: Change postgresql encoding

2015-02-09 7:52 GMT+00:00 Oliver <ofabelo(at)gmail(dot)com>:

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

If I set encoding to latin9, lc_collate and lc_ctype to 'C', database is
created correctly, but I'm not sure if it is ok :-? I want have database
with iso8859-15 encoding.
My system has, when I run 'locale', the next:

LANG=es_ES.UTF-8
LC_CTYPE="es_ES.UTF-8"
LC_NUMERIC="es_ES.UTF-8"
LC_TIME="es_ES.UTF-8"
LC_COLLATE="es_ES.UTF-8"
LC_MONETARY="es_ES.UTF-8"
LC_MESSAGES="es_ES.UTF-8"
LC_PAPER="es_ES.UTF-8"
LC_NAME="es_ES.UTF-8"
LC_ADDRESS="es_ES.UTF-8"
LC_TELEPHONE="es_ES.UTF-8"
LC_MEASUREMENT="es_ES.UTF-8"
LC_IDENTIFICATION="es_ES.UTF-8"
LC_ALL=

Thanks beforehand.