Re: [ADMIN] Change postgresql encoding

Hello Adrian,

Not sure if this is what your looking for insofar as a solution but have
you taken a look at this page from the documentation.

http://www.postgresql.org/docs/9.3/static/multibyte.html

On Mon, Feb 9, 2015 at 12:11 AM, Oliver <ofabelo(at)gmail(dot)com> wrote:

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

--
Jeremiah Ocasio
jocasio(at)kaleidoscopemediasystems(dot)com

1200 Westlake Ave N, Suite 604
Seattle, WA 98109
Tel: 855-247-5231
Fax: 206-400-2712

This electronic mail communication is intended only for the individual or
entity to which it is addressed and contains privileged and confidential
information. If you receive this communication in error, please advise us
by return e-mail or call us immediately at 855-247-5231 and delete this
communication and all copies and attachments. Any dissemination,
distribution or copying of this communication is strictly prohibited.

IRS Circular 230 disclosure: To ensure compliance with requirements imposed
by the IRS and other taxing authorities, we inform you that any tax advice
contained in this communication (including any attachments) is not intended
or written to be used, and cannot be used, for the purpose of (i) avoiding
penalties that may be imposed on any taxpayer or (ii) promoting, marketing
or recommending to another party any transaction or matter addressed herein.