Skip site navigation (1) Skip section navigation (2)

Проблема чувствительности регистра

From: "Sergey Konoplev" <gray(dot)ru(at)gmail(dot)com>
To: pgsql-ru-general(at)postgresql(dot)org
Subject: Проблема чувствительности регистра
Date: 2007-09-07 14:00:46
Message-ID: c3a7de1f0709070700k6fe09953u7b7257e4d0a3fb00@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-ru-general
Привет

Кто-нибудь может объяснить мне, почему во втором случае возвращается
одна строка?

pgdb:~ # locale |grep LC_CTYPE
LC_CTYPE=ru_RU.UTF-8
pgdb:~ # /opt/PostgreSQL/bin/psql -d test -U postgres
Welcome to psql 8.2.4, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
      \h for help with SQL commands
      \? for help with psql commands
      \g or terminate with semicolon to execute query
      \q to quit

test=# show client_encoding;
 client_encoding
-----------------
 UTF8
(1 row)

test=# create table test_table ( t_string varchar );
CREATE TABLE
test=# insert into test_table values ('Йцукен');
INSERT 0 1
test=# insert into test_table values ('йцукен');
INSERT 0 1
test=# select * from test_table where t_string ilike 'Й%';
 t_string
----------
 Йцукен
 йцукен
(2 rows)

test=# select *  from test_table where t_string ~* E'Й';
 t_string
----------
 Йцукен
(1 row)


--
Regards,
Sergey Konoplev

Responses

pgsql-ru-general by date

Next:From: Teodor SigaevDate: 2007-09-07 14:10:58
Subject: Re: Проблема чувствительности регистра
Previous:From: Dmitriy MiksIrDate: 2007-09-07 13:30:07
Subject: Совет по конфигурации

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group