"James B. Byrne" <byrn...@harte-lyne.ca> writes:
> PG::Error: ERROR:  encoding "UTF8" does not match locale
> "en...@yyyy-mmm-dd.utf-8"
> DETAIL:  The chosen LC_CTYPE setting requires encoding "LATIN1".
> : CREATE DATABASE "hll_th_forex_test" ENCODING = 'UTF8' TEMPLATE =
> "template1"

> I am constructing this remotely using a Rake task borrowed from Ruby
> on Rails 3.2.9 and employing ActiveRecord-3.2.9.  We use a custom
> local on all our servers "en...@yyyy-mmm-dd.utf-8" which differs from
> en_CA only in the presentation of the date.

Sorta looks like you based that locale on an ISO 8859-1 locale, not a
UTF8 locale.  AFAICT from looking at the code, PG is seeing that
nl_langinfo(CODESET) returns "ISO-8859-1" or some variant spelling,
so it complains.

                        regards, tom lane


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to