Stefan Sassenberg <stefan.sassenberg@xxxxxx> 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
