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

BUG #2472: Incorrect ILIKE, ~* for Cyrilic symbols.

From: "Boris" <boris_k(at)iname(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2472: Incorrect ILIKE, ~* for Cyrilic symbols.
Date: 2006-06-06 15:44:48
Message-ID: 200606061544.k56FimcN024779@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2472
Logged by:          Boris
Email address:      boris_k(at)iname(dot)com
PostgreSQL version: 8.1.4
Operating system:   win2000
Description:        Incorrect ILIKE, ~*  for Cyrilic symbols.
Details: 

Microsoft Windows 2000 [Version 5.00.2195]
PosgreSql 8.1.4
PgAdmin 1.4.2 III
for Cyrilis symbols ~* and ILIKE return wrong result
data base is created by:
 initdb.exe  -E UTF8 --lc-collate=UTF8 --lc-ctype=UTF8  "c:\Program
Files\PostgreSQL\8.1\basewin1251\"

then...
postmaster.exe -D "c:\Program Files\PostgreSQL\8.1\basewin1251\"
then
connect to server on local w PgAdmin 1.4.2 III
I see db:

CREATE DATABASE postgres
  WITH OWNER = postgres
       ENCODING = 'UTF8'
       TABLESPACE = pg_default;

Go to SQL Query
SELECT upper(' '), lower(' '),
''ILIKE''

return incorrect FALSE for last ILIKE
It must be TRUE

ICQ 176869864 for more info

pgsql-bugs by date

Next:From: Bruno Wolff IIIDate: 2006-06-06 19:57:14
Subject: Re: BUG #2468: how to create auto-generate primary key
Previous:From: AdamDate: 2006-06-06 13:43:06
Subject: Problem configuring PostgreSQL 8.1.4 on Mac OS X

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