Thread: ERROR: encoding LATIN9 does not match server's locale en_US
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
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
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...).