Re: [GENERAL] [SOLVED] Problems with a custom LOCALE

2012-12-17 Thread Tom Lane
"James B. Byrne" 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' > S

Re: [GENERAL] [SOLVED] Problems with a custom LOCALE

2012-12-17 Thread James B. Byrne
On Sun, December 16, 2012 15:13, 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". > >> This is what I see on the host running postgresql-9.2