X-Original-To: pgsql-ru-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 334EA536C8 for ; Fri, 29 Apr 2005 07:00:04 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66284-03 for ; Fri, 29 Apr 2005 09:59:52 +0000 (GMT) Received: from beta.sbin.org (beta.sbin.org [217.106.81.40]) by svr1.postgresql.org (Postfix) with ESMTP id 739B8536F0 for ; Fri, 29 Apr 2005 06:59:48 -0300 (ADT) Received: from [192.168.1.1] (beta.sbin.org [192.168.1.1]) (authenticated bits=0) by beta.sbin.org (8.13.3/8.13.3) with ESMTP id j3T9xnjN024546 for ; Fri, 29 Apr 2005 13:59:49 +0400 Message-ID: <42720594.8050407@sbin.org> Date: Fri, 29 Apr 2005 13:59:48 +0400 From: Nick Gazaloff User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 Cc: pgsql-ru-general Subject: =?KOI8-R?Q?Re=3A_=5Bpgsql-ru-general=5D_Re=3A_=5Bpgsql-ru-?= =?KOI8-R?Q?general=5D_Re=3A_=5Bpgsql-ru-general=5D_Re=3A_=5Bpgsq?= =?KOI8-R?Q?l-ru-general=5D_Re=3A_=5Bpgsql-ru-general=5D_ILIKE_=D3?= =?KOI8-R?Q?_=D2=D5=D3=D3=CB=C9=CD=C9_=CE=C5_=D2=C1=C2=CF=D4=C1=C5=D4?= =?KOI8-R?Q?=3F?= References: <426C6626.1050903@lukoilperm.ru> <426C96DC.6030707@lukoilperm.ru> <426CA439.4090105@lukoilperm.ru> <4271BFFD.7060905@lukoilperm.ru> In-Reply-To: <4271BFFD.7060905@lukoilperm.ru> X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 8bit X-Authenticated-Sender: user nick@sbin.org from 192.168.1.1 X-Virus-Scanned: ClamAV version 0.81, clamav-milter version 0.81b on beta.sbin.org X-Virus-Status: Clean X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.065 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/109 X-Sequence-Number: 300 Viktor Vislobokov wrote: > >>> >>>> 2. как ты делали initdb ? >>> >>> >>> >>> initdb делается автоматом при первом запуске службы PostgreSQL. >>> Делается, насколько я понимаю в системной локали, но для PostgreSQL >>> как ASCII (судя по выводу \l в psql). >> >> >> >> сделай в ru_RU.UTF8 >> > Сделал. Ничего не изменилось. ILIKE в UTF-8 не работает. Покажи вывод show LC_COLLATE; show LC_CTYPE; -- С уважением, технический директор ООО "ЦСА" Николай Газалов www.sbin.org +7 8793 365584 (GPG Key ID: 4396B2D0)