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,
Select 'a' ILIKE 'A'
Select '' ILIKE ''
Select 'a' ~* 'A'
Select '' ~* ''
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: SunWuKung||Date: 2006-04-21 19:42:52|
|Subject: Re: BUG #2400: 'Ã' considered invalid UTF-8 character|
|Previous:||From: Robert Lor||Date: 2006-04-21 15:13:11|
|Subject: Re: BUG #2401: spinlocks not available on amd64|