"James B. Byrne" <byrnejb@xxxxxxxxxxxxx> writes: > PG::Error: ERROR: encoding "UTF8" does not match locale > "en_CA@xxxxxxxxxxxxxxx-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_CA@xxxxxxxxxxxxxxx-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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
