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

2006-09-05 Thread Tom Lane
Volkan YAZICI <[EMAIL PROTECTED]> writes: > Looks like regex code needs same modifications done to ILIKE command. Regex is still broken but I don't think the same fix is feasible -- we can't blindly downcase the strings outside the regex package (consider embedded ARE options). And even if we did

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

2006-09-05 Thread Victor Snezhko
Victor Snezhko <[EMAIL PROTECTED]> writes: > 2) When I try to create a stored procedure to create table (e.g., for >creating table only if it doesn't already exist), it fails to >compile if i use cyrillic letter "х" (unicode id: 0x0445, utf-8 >representation is D1 85) with the followin

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

2006-09-05 Thread Victor Snezhko
Volkan YAZICI <[EMAIL PROTECTED]> writes: > On Sep 04 02:35, Tom Lane wrote: >> "Devrim GUNDUZ" <[EMAIL PROTECTED]> writes: >> > Like the bug report that was submitted a few days ago, >> > http://archives.postgresql.org/pgsql-bugs/2005-09/msg00233.php >> > I have the same thing for Turkish locale.

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

2006-09-05 Thread Volkan YAZICI
On Sep 04 02:35, Tom Lane wrote: > "Devrim GUNDUZ" <[EMAIL PROTECTED]> writes: > > Like the bug report that was submitted a few days ago, > > http://archives.postgresql.org/pgsql-bugs/2005-09/msg00233.php > > I have the same thing for Turkish locale. > > Would you confirm that this is fixed by my