pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
ERROR: encoding LATIN9 does not match server's locale en_US
3+ messages / 3 participants
[nested] [flat]

* ERROR: encoding LATIN9 does not match server's locale en_US
@ 2008-04-01 17:28 Arnau <arnaulist@andromeiberica.com>
  2008-04-01 18:11 ` Re: ERROR: encoding LATIN9 does not match server's locale en_US Tom Lane <tgl@sss.pgh.pa.us>
  0 siblings, 1 reply; 3+ messages in thread

From: Arnau @ 2008-04-01 17:28 UTC (permalink / raw)
  To: pgsql-admin

Hi all,

  Using PostgreSQL 8.3.0 I'm trying to do the following:

template1=# create database test with encoding='LATIN9';
ERROR:  encoding LATIN9 does not match server's locale en_US
DETAIL:  The server's LC_CTYPE setting requires encoding LATIN1.

  I've been looking into the documentation to fix this and the only way 
I have found is to use initdb to recreate the cluster, Is there any 
other option?

Thanks
-- 
Arnau



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: ERROR: encoding LATIN9 does not match server's locale en_US
  2008-04-01 17:28 ERROR: encoding LATIN9 does not match server's locale en_US Arnau <arnaulist@andromeiberica.com>
@ 2008-04-01 18:11 ` Tom Lane <tgl@sss.pgh.pa.us>
  2008-04-02 09:02   ` Re: ERROR: encoding LATIN9 does not match server's locale en_US Harald Fuchs <hari.fuchs@googlemail.com>
  0 siblings, 1 reply; 3+ messages in thread

From: Tom Lane @ 2008-04-01 18:11 UTC (permalink / raw)
  To: arnaulist@andromeiberica.com; +Cc: pgsql-admin

Arnau <arnaulist@andromeiberica.com> writes:
> template1=# create database test with encoding='LATIN9';
> ERROR:  encoding LATIN9 does not match server's locale en_US
> DETAIL:  The server's LC_CTYPE setting requires encoding LATIN1.

>   I've been looking into the documentation to fix this and the only way 
> I have found is to use initdb to recreate the cluster, Is there any 
> other option?

Nope, sorry.  If you need to change the database locale, you have to
re-initdb.

			regards, tom lane



^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: ERROR: encoding LATIN9 does not match server's locale en_US
  2008-04-01 17:28 ERROR: encoding LATIN9 does not match server's locale en_US Arnau <arnaulist@andromeiberica.com>
  2008-04-01 18:11 ` Re: ERROR: encoding LATIN9 does not match server's locale en_US Tom Lane <tgl@sss.pgh.pa.us>
@ 2008-04-02 09:02   ` Harald Fuchs <hari.fuchs@googlemail.com>
  0 siblings, 0 replies; 3+ messages in thread

From: Harald Fuchs @ 2008-04-02 09:02 UTC (permalink / raw)
  To: pgsql-admin

In article <11865.1207073502@sss.pgh.pa.us>,
Tom Lane <tgl@sss.pgh.pa.us> writes:

> Arnau <arnaulist@andromeiberica.com> writes:
>> template1=# create database test with encoding='LATIN9';
>> ERROR:  encoding LATIN9 does not match server's locale en_US
>> DETAIL:  The server's LC_CTYPE setting requires encoding LATIN1.

>> I've been looking into the documentation to fix this and the only way 
>> I have found is to use initdb to recreate the cluster, Is there any 
>> other option?

> Nope, sorry.  If you need to change the database locale, you have to
> re-initdb.

Are there any characters in American English which are covered by
Latin-1, but not by Latin-9?  I consider Latin-1 mostly obsolete (no
French OE ligature, no Euro sign...).




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2008-04-02 09:02 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-04-01 17:28 ERROR: encoding LATIN9 does not match server's locale en_US Arnau <arnaulist@andromeiberica.com>
2008-04-01 18:11 ` Tom Lane <tgl@sss.pgh.pa.us>
2008-04-02 09:02   ` Harald Fuchs <hari.fuchs@googlemail.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox