From: Tom Lane <tgl@sss.pgh.pa.us>
To: willy malth <donotemailme@nosuchdomain.xx>
Cc: pgsql-sql@postgresql.org
Subject: Re: select lower('ÆØÅ ABC'); does not work as expected
Date: Sat, 24 May 2003 23:07:31 -0400
Message-ID: <2862.1053832051@sss.pgh.pa.us> (raw)
In-Reply-To: <1kqza.10221$YZ6.333198@news010.worldonline.dk>
References: <1kqza.10221$YZ6.333198@news010.worldonline.dk>
willy malth <donotemailme@nosuchdomain.xx> writes:
> I'm useing postgresql 7.3.2, and having trouble with the lower(string)
> function and the Danish special chars:
> The Danish chars does not convert to lower chars.
You need to run initdb in the correct locale. LC_COLLATE and LC_CTYPE
are both locked down at initdb time, and the latter determines the
behavior of lower(). You could use pg_controldata to check the
database's LC_CTYPE, but I'll bet that it's not a Danish locale.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, donotemailme@nosuchdomain.xx
Subject: Re: select lower('ÆØÅ ABC'); does not work as expected
In-Reply-To: <2862.1053832051@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox