Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: BUG #2592: ILIKE does not care about locales
- From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
- To: Tino Schwarze <tino(dot)schwarze(at)tisc(dot)de>
- Cc: pgsql-bugs(at)postgresql(dot)org
- Subject: Re: BUG #2592: ILIKE does not care about locales
- Date: Tue, 29 Aug 2006 09:27:59 -0400
Tino Schwarze <tino(dot)schwarze(at)tisc(dot)de> writes: > On Sun, Aug 27, 2006 at 12:58:00PM +0000, Robert Siemer wrote: >> I tried this with LC_COLLATE=C and the rest LC_...=es_ES.utf8 >> >> dennisb from irc reported LC_everything=sv_SE.UTF-8 with version 8.1.0 >> having the same problems. > I can confirm this with de_DE.utf8. ilike currently doesn't work for multibyte encodings (eg utf8). This bug has been known for a long while, eg, http://archives.postgresql.org/pgsql-bugs/2005-10/msg00002.php but no one's stepped up to fix it. regards, tom lane
- Follow-Ups:
- Re: BUG #2592: ILIKE does not care about locales
- From: Tino Schwarze
- Re: BUG #2592: ILIKE does not care about locales
- References:
- BUG #2592: ILIKE does not care about locales
- From: Robert Siemer
- Re: BUG #2592: ILIKE does not care about locales
- From: Tino Schwarze
- BUG #2592: ILIKE does not care about locales
- Prev by Date: Re: BUG #2592: ILIKE does not care about locales
- Next by Date: Re: BUG #2592: ILIKE does not care about locales
- Previous by thread: Re: BUG #2592: ILIKE does not care about locales
- Next by thread: Re: BUG #2592: ILIKE does not care about locales
- Indexes: