Re: [GENERAL] Problems with a custom LOCALE

2012-12-16 Thread Tom Lane
"James B. Byrne" writes: >>> PG::Error: ERROR: encoding "UTF8" does not match locale >>> "en...@-mmm-dd.utf-8" >>> DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1". > This is what I see on the host running postgresql-9.2 > # LC_ALL=en_CA@-mmm-dd.utf8 locale charmap > UTF-8

Re: [GENERAL] Problems with a custom LOCALE

2012-12-16 Thread James B. Byrne
On Fri, December 14, 2012 17:40, Tom Lane wrote: > "James B. Byrne" writes: >> PG::Error: ERROR: encoding "UTF8" does not match locale >> "en...@-mmm-dd.utf-8" >> DETAIL: The chosen LC_CTYPE setting requires encoding "LATIN1". >> : CREATE DATABASE "hll_th_forex_test" ENCODING = 'UTF8' TEMPL

Re: [GENERAL] Problems with a custom LOCALE

2012-12-14 Thread Tom Lane
"James B. Byrne" writes: > PG::Error: ERROR: encoding "UTF8" does not match locale > "en...@-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 u