In article <11865.1207073502@xxxxxxxxxxxxx>, Tom Lane <tgl@xxxxxxxxxxxxx> writes: > Arnau <arnaulist@xxxxxxxxxxxxxxxxxx> 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...). -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
