Re: [BUGS] BUG #1931: ILIKE and LIKE fails on Turkish locale

2005-10-01 Thread Tom Lane
Devrim GUNDUZ <[EMAIL PROTECTED]> writes: > On Sat, 1 Oct 2005, Tom Lane wrote: >> So yeah, ILIKE looks just about completely broken for multibyte encodings. >> The regexp code doesn't look better, btw, just differently broken ... > So any chance to fix it before beta 3 (and also backpatch?) ? Ar

Re: [BUGS] BUG #1931: ILIKE and LIKE fails on Turkish locale

2005-10-01 Thread Devrim GUNDUZ
Hi Tom, On Sat, 1 Oct 2005, Tom Lane wrote: So yeah, ILIKE looks just about completely broken for multibyte encodings. Maybe it would be best to pass both strings through lower() and then do a normal LIKE comparison? The regexp code doesn't look better, btw, just differently broken ... So

Re: [BUGS] BUG #1931: ILIKE and LIKE fails on Turkish locale

2005-10-01 Thread Tom Lane
"Devrim GUNDUZ" <[EMAIL PROTECTED]> writes: > http://sourceware.org/bugzilla/long_list.cgi?buglist=1354 > So it is PostgreSQL's bug or Glibc's? Just offhand, iwchareq() seems several bricks shy of a load: /* * if one of them is an ASCII while the other is not, then they must * be di

[BUGS] BUG #1931: ILIKE and LIKE fails on Turkish locale

2005-10-01 Thread Devrim GUNDUZ
The following bug has been logged online: Bug reference: 1931 Logged by: Devrim GUNDUZ Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1beta2 Operating system: Linux (RHEL 4, Debian 3.1) Description:ILIKE and LIKE fails on Turkish locale Details: Hi, Like th

Re: [BUGS] BUG #1927: incorrect timestamp returned

2005-10-01 Thread Gaetano Mendola
Deyan Chepishev wrote: > The following bug has been logged online: > > Bug reference: 1927 > Logged by: Deyan Chepishev > Email address: [EMAIL PROTECTED] > PostgreSQL version: 7.4.8, 8.0.3 > Operating system: Linux > Description:incorrect timestamp returned > Details: