Re: BUG #3737: lower/upper fails to match extended chars in LATIN1 - Mailing list pgsql-bugs

Jonas Forsman wrote:
> it is possibly a locale-error. may I ask:
> 1. How do I check the locale?

Within psql:

show lc_ctype; (and other lc_* variables as well)
show server_encoding;
show client_encoding;

> 2. Can I change this on already running db:s ?

Unfortunately you can't. You'll have to re-initdb. :-(

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com