From: | Oliver <ofabelo(at)gmail(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | Forums postgresql <pgsql-general(at)postgresql(dot)org>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Change postgresql encoding |
Date: | 2015-02-09 08:11:25 |
Message-ID: | CALQkqm8TkhTb2JvVFj2Gzr7i0d=LBAYV-V5AXW5rKtRKiaLsOQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-general |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver | 2015-02-09 08:11:53 | Re: Change postgresql encoding |
Previous Message | Oliver | 2015-02-09 07:54:25 | Re: Change postgresql encoding |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver | 2015-02-09 08:11:53 | Re: Change postgresql encoding |
Previous Message | Oliver | 2015-02-09 07:54:25 | Re: Change postgresql encoding |