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

BUG #2402: case insensitive match for unicode doesn't work

From: "Balzs Klein" <balazs(dot)klein(at)t-online(dot)hu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2402: case insensitive match for unicode doesn't work
Date: 2006-04-21 17:29:54
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2402
Logged by:          Balzs Klein
Email address:      balazs(dot)klein(at)t-online(dot)hu
PostgreSQL version: 8.1
Operating system:   Gentoo Linux
Description:        case insensitive match for unicode doesn't work

case conversion and case insensitive match (with or without regular
expression) does not work with non standard (Greek, Turkish, Hungarian,
etc.) characters


Select 'a' ILIKE 'A'

Select '' ILIKE ''

Select 'a' ~* 'A'

Select '' ~* ''

Select upper('a')='A'

Select upper('')=''

You would get the same result with ,,,, or with many Greek
characters that I tried. 

I raised this issue on pgsql.general -
but there didn't seem to be an easy workaround for this

On a sidenote SQLServer2000 and Access also make mistakes with the
equivalent of upper/lower function but they give correct result with more
characters than PG. Which at least consistently fails:)



pgsql-bugs by date

Next:From: SunWuKungDate: 2006-04-21 19:42:52
Subject: Re: BUG #2400: 'Ã' considered invalid UTF-8 character
Previous:From: Robert LorDate: 2006-04-21 15:13:11
Subject: Re: BUG #2401: spinlocks not available on amd64

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