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@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