2015-02-09 7:54 GMT+00:00 Oliver <ofab...@gmail.com>: > 2015-02-08 20:50 GMT+00:00 BladeOfLight16 <bladeofligh...@gmail.com>: > >> On Sun, Feb 8, 2015 at 2:20 PM, Oliver <ofab...@gmail.com> wrote: >> >>> 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) >>> >> >> I can't answer your question about whether the encodings need to be the >> same, but I'm pretty sure that's not true. CREATE DATABASE has options to >> set the encoding for a database: >> >> CREATE DATABASE korean WITH ENCODING 'EUC_KR' LC_COLLATE='ko_KR.euckr' >> LC_CTYPE='ko_KR.euckr' TEMPLATE=template0; >> >> (From http://www.postgresql.org/docs/9.4/static/multibyte.html) >> >> To change the encoding of an existing PG database, you have to 1) dump >> it, 2) create a new, empty DB with the desired encoding, and 3) import the >> dump into the new DB. So you can't really change it "on the fly," but it >> can be done at creation time. >> > > How it would be if I want latin9 encoding? I'm trying the next but it > shows that it is not valid (es_ES.latin9): > > 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; > > Thanks beforehand. > > 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.
