"James B. Byrne" <byrnejb@xxxxxxxxxxxxx> writes: > PG::Error: ERROR: new encoding (UTF8) is incompatible with the > encoding of the template database (LATIN1) > HINT: Use the same encoding as in the template database, or use > template0 as template. > : CREATE DATABASE "hll_th_forex_development" ENCODING = 'UTF-8' > So, I now must specify a template in the database connection, where I > did not need to before. Furthermore, the template I must use is > template0 because regardless of what locale initdb is run in template1 > evidently is always created with LATIN1 encoding. At lease if there > is a way to force template1 to utf8 during initdb I now lack the > energy to discover it. You could use initdb's -E option, but really it ought to default to the charmap of the locale that prevails from its environment. I suspect there's still something wonky about your custom locale. (But man, your description of localedef is scary.) regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
