pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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> 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 18:11 Tom Lane <tgl@sss.pgh.pa.us> parent: Arnau <arnaulist@andromeiberica.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-02 09:02 Harald Fuchs <hari.fuchs@googlemail.com> parent: Tom Lane <tgl@sss.pgh.pa.us> 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