agora inbox for pgsql-ru-general@postgresql.org  

help / color / mirror / Atom feed

From: Viktor Vislobokov <vvislobokov@parma-telecom.ru>
To: pgsql-ru-general <pgsql-ru-general@postgresql.org>
Subject: ILIKE с русскими не работает?
Date: Mon, 25 Apr 2005 09:38:14 +0600
Message-ID: <426C6626.1050903@lukoilperm.ru> (raw)

Собственно subj?

Проверяю:
template1=# CREATE DATABASE tmp WITH ENCODING='utf8';
CREATE DATABASE
template1=# CREATE TABLE tmp_tbl (id int not null primary key, name 
varchar(20));
NOTICE:  CREATE TABLE / PRIMARY KEY создаст подразумеваемый индекс 
"tmp_tbl_pkey" для таблицы "tmp_tbl"
CREATE TABLE
template1=# INSERT INTO tmp_tbl VALUES(1, 'Вагон');
INSERT 17182 1
template1=# SELECT * FROM tmp_tbl WHERE name ILIKE ('Ва%');
 id |    name
----+------------
  1 | Вагон
(1 запись)

template1=# select * from tmp_tbl where name ILIKE ('ва%');
 id | name
----+------
(записей: 0)

template1=#

Есть проблема или я что-то не так делаю?

-- 
С уважением, Виктор

Message-ID: <426C6626.1050903@lukoilperm.ru>
Permalink:  ../426C6626.1050903@lukoilperm.ru/
Also on:    postgresql.org/message-id/426C6626.1050903@lukoilperm.ru

reply

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-ru-general@postgresql.org
  Cc: vvislobokov@parma-telecom.ru
  Subject: Re: ILIKE =?KOI8-R?Q?=D3_=D2=D5=D3=D3=CB=C9=CD=C9_=CE=C5_=D2=C1?= =?KOI8-R?Q?=C2=CF=D4=C1=C5=D4=3F?=
  In-Reply-To: <426C6626.1050903@lukoilperm.ru>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox