Stefan Sassenberg <stefan.sassenberg@gmx.de> writes:
> de_DE@euro is ISO-8859-15, if that helps. I changed the locale to
> en_US.UTF-8 and LC_CTYPE in the environment is set to that value too.
> Nevertheless "show lc_ctype" says de_DE@euro, even after a postgresql
> restart. How can I change that?
initdb is the only way to change the database's LC_CTYPE or LC_COLLATE :-(
regards, tom lane