2015-02-09 7:52 GMT+00:00 Oliver <[email protected]>: > 2015-02-08 20:44 GMT+00:00 Adrian Klaver <[email protected]>: > >> 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 >> [email protected] > >
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.
