Re: BUG #3737: lower/upper fails to match extended chars in LATIN1

From: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
To: Jonas Forsman <jonas(at)axier(dot)se>
Cc: PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #3737: lower/upper fails to match extended chars in LATIN1
Date: 2007-11-09 17:24:31
Message-ID: 473497CF.8090500@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2007-11-09 18:49:27 Re: BUG #3730: Creating a swedish dictionary fails
Previous Message Bruce Momjian 2007-11-09 17:22:29 Re: Revisiting BUG #3684: After dump/restore, schema PUBLIC always exists