lc_ctype and lower()

From: Gábor Farkas <gabor(at)nekomancer(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: lc_ctype and lower()
Date: 2008-07-11 11:11:25
Message-ID: 2c173a350807110411n440152ddh478d280bce240883@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi,

i have a postgresql-8.2 database instance,
which contained in the past a latin9 database.

this database was later converted to utf8 (by dumping and reloading it).

everything works fine, except that

SELECT lower("Gábor")

returns "gbor" (the 'á' is dropped).

the problem seems to be that

"SHOW lc_ctype" returns "de_AT(at)euro".

(on a testing db-instance, "SHOW lc_ctype" returns "en_US.UTF-8", and
everything is ok)

based on this, i assume that when the database instance was created
(by "initdb"),
it was created with this locale, and because of this, lower() is not working
correctly with utf8 data.

my question is:

is this a correct assumption?

if yes, is there any way to change this locale-setting somehow?

is the only solution to create a new database-instance? (initdb, new
port, etc.) ? or is there a simpler way?

thanks,
gabor

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2008-07-11 11:37:56 Re: lc_ctype and lower()
Previous Message Richard Huxton 2008-07-11 08:24:05 Re: view row-level locks