Vegard Munthe <vegard@copyleft.no> writes:
> 'SELECT lower('�')' returns �. I have tried server_encoding and
> client_encoding LATIN1 and ASCII.
The behavior of lower() is driven by locale, not encoding.
Unfortunately you'll need to re-initdb to change the database locale.
regards, tom lane