Re: [ADMIN] [GENERAL] Change postgresql encoding

2015-02-10 Thread Oliver
Thanks, problem was mine, all is ok now, thanks. I were putting es_ES@iso885915 or es_ES@latin9 and it wasn't working .. Solution was using es_ES.iso885915@euro for collation and ctype (and latin9 for encoding). Thanks to all! Regards... 2015-02-10 23:26 GMT+00:00 Jeremiah Ocasio < joca...@kaleid

Re: [ADMIN] [GENERAL] Change postgresql encoding

2015-02-10 Thread Jeremiah Ocasio
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 wrote: > 2015-02-09 7:52 GMT+00:00 Oliver : > >> 2015-

Re: [GENERAL] Change postgresql encoding

2015-02-09 Thread Oliver
2015-02-09 14:01 GMT+00:00 Vincent Veyron : > On Mon, 9 Feb 2015 08:11:25 + > Oliver wrote: > > > 2015-02-09 7:52 GMT+00:00 Oliver : > > > > > regional configuration name not valid <> > > > SQL state: 42809 > > > > > > I've tried es_ES.iso8859-15 and same error. > > > > > If I set encoding to

Re: [GENERAL] Change postgresql encoding

2015-02-09 Thread Vincent Veyron
On Mon, 9 Feb 2015 08:11:25 + Oliver wrote: > 2015-02-09 7:52 GMT+00:00 Oliver : > > > regional configuration name not valid <> > > SQL state: 42809 > > > > I've tried es_ES.iso8859-15 and same error. > > If I set encoding to latin9, lc_collate and lc_ctype to 'C', database is > created co

Re: [GENERAL] Change postgresql encoding

2015-02-09 Thread Nicolas Paris
Hello, TRY in psql : update pg_database set encoding = pg_char_to_encoding('your_encoding') where datname = 'your_data_base'; Works for postgres 9.3 Nicolas PARIS 2015-02-09 9:11 GMT+01:00 Oliver : > 2015-02-09 7:54 GMT+00:00 Oliver : > >> 2015-02-08 20:50 GMT+00:00 BladeOfLight16 : >> >>> On

Re: [GENERAL] Change postgresql encoding

2015-02-09 Thread Oliver
2015-02-09 7:54 GMT+00:00 Oliver : > 2015-02-08 20:50 GMT+00:00 BladeOfLight16 : > >> On Sun, Feb 8, 2015 at 2:20 PM, Oliver 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 h

Re: [GENERAL] Change postgresql encoding

2015-02-09 Thread Oliver
2015-02-09 7:52 GMT+00:00 Oliver : > 2015-02-08 20:44 GMT+00:00 Adrian Klaver : > >> 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 ch

Re: [GENERAL] Change postgresql encoding

2015-02-08 Thread Oliver
2015-02-08 20:50 GMT+00:00 BladeOfLight16 : > On Sun, Feb 8, 2015 at 2:20 PM, Oliver 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 abou

Re: [GENERAL] Change postgresql encoding

2015-02-08 Thread Oliver
2015-02-08 20:44 GMT+00:00 Adrian Klaver : > 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 encod

Re: [GENERAL] Change postgresql encoding

2015-02-08 Thread BladeOfLight16
On Sun, Feb 8, 2015 at 2:20 PM, Oliver 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 pr

Re: [GENERAL] Change postgresql encoding

2015-02-08 Thread Adrian Klaver
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 post

[GENERAL] Change postgresql encoding

2015-02-08 Thread Oliver
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