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 recent commit?
I've made some tests. [AFAICS, below results are applicable for all latinN encodings.] Cluster Locale | client_encoding | upper() | lower() | ILIKE | ~* -----------------+-----------------+---------+---------+-------+---- tr_TR.iso8859-9 | LATIN5 | OK | OK | OK | OK tr_TR.iso8859-9 | UTF8 | OK | OK | OK | OK tr_TR.UTF-8 | LATIN5 | OK | OK | OK | FAILS tr_TR.UTF-8 | UTF8 | OK | OK | OK | FAILS Looks like regex code needs same modifications done to ILIKE command. Regards. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings