Stefan Sassenberg <[EMAIL PROTECTED]> writes: > [EMAIL PROTECTED] 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 [EMAIL PROTECTED], 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 ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match