X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 7B1A7D1C4E3 for ; Mon, 11 Aug 2003 04:16:09 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 40067-09 for ; Mon, 11 Aug 2003 01:14:39 -0300 (ADT) Received: from gw.ac-sw.com (gw.ac-sw.com [81.1.223.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8E099D1C4D9 for ; Mon, 11 Aug 2003 01:15:57 -0300 (ADT) Received: from lan.ac-sw.com (unknown [192.168.0.69]) by gw.ac-sw.com (Postfix) with ESMTP id 03E89BD28; Mon, 11 Aug 2003 11:15:56 +0700 (NOVST) Received: from lan (localhost [127.0.0.1]) by lan.ac-sw.com (Postfix on SuSE Linux 8.0 (i386)) with ESMTP id 217EA14E4FE; Mon, 11 Aug 2003 10:35:13 +0700 (NOVST) Content-Type: text/plain; charset="iso-8859-1" From: Alexander Litvinov To: Bruce Momjian , Eugeny Balakhonov Subject: Re: PostgreSQL Date: Mon, 11 Aug 2003 10:35:09 +0700 User-Agent: KMail/1.4.3 Cc: pgsql-general@postgresql.org References: <200308110401.h7B41kp10302@candle.pha.pa.us> In-Reply-To: <200308110401.h7B41kp10302@candle.pha.pa.us> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200308111035.12364.lan@ac-sw.com> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/472 X-Sequence-Number: 46889 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I confirm this behavour: cyrilic words are not changed by lower()/upper()= =20 functions, nor catched by ilike. I am using : =3D> SELECT version(); version - --------------------------------------------------------------- PostgreSQL 7.2.2 on i686-pc-linux-gnu, compiled by GCC 2.95.2 (1 row) Nothing special was done during database creation (no encoding selected). > Not sure. I thought it would work. > > How to use string functions (like UPPER()/LOWER()) for non-latin string= s? > > Why UPPER() function doesn't work with my UNICODE PostgreSQL database > > which contains non-latin characters (like cyrillic)? How to make case > > insensetive search by text field which contains non-latin characters? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iD8DBQE/Nw7wV+WKOINIfOYRAuhmAJwMEkdgqXkt6ZhgJsFZfQH2mELRwgCfeDeV L9TbSItEb0tAC7cI0cKwg6A=3D =3DveHN -----END PGP SIGNATURE-----