X-Original-To: pgsql-sql@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id CD17A925593 for ; Sat, 24 May 2003 23:07:32 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 18313-04 for ; Sat, 24 May 2003 23:07:32 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by developer.postgresql.org (Postfix) with ESMTP id 0CCAA92558F for ; Sat, 24 May 2003 23:07:32 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.9/8.12.9) with ESMTP id h4P37VU6002863; Sat, 24 May 2003 23:07:31 -0400 (EDT) To: willy malth Cc: pgsql-sql@postgresql.org Subject: Re: select =?ISO-8859-1?Q?lower=28=27=C6=D8=C5_ABC=27=29=3B_does?= =?ISO-8859-1?Q?_not_work_as_expected?= In-reply-to: <1kqza.10221$YZ6.333198@news010.worldonline.dk> References: <1kqza.10221$YZ6.333198@news010.worldonline.dk> Comments: In-reply-to willy malth message dated "Fri, 23 May 2003 16:33:45 +0200" Date: Sat, 24 May 2003 23:07:31 -0400 Message-ID: <2862.1053832051@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/485 X-Sequence-Number: 13650 willy malth 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