Re: BUG #1931: ILIKE and LIKE fails on Turkish locale - Mailing list pgsql-bugs

From Douglas Toltzman
Subject Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Date
Msg-id 6ECC1F64-F98A-493D-B96F-B11A52F95164@oakstreetsoftware.com
Whole thread Raw
In response to Re: BUG #1931: ILIKE and LIKE fails on Turkish locale  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Mac OS X is based on FreeBSD.  I'm not sure if this is what you want,=20=20
because I'm not in a Turkish locale, but ...

#include <stdio.h>
#include <ctype.h>

int main()
{
         printf("isspace(0x85) returned %d\n", isspace(0x85));
}

produces:

isspace(0x85) returned 0

... on my Mac OS X 10.4.7 PPC box.

On Sep 22, 2006, at 12:48 PM, Tom Lane wrote:

> Victor Snezhko <snezhko@indorsoft.ru> writes:
>> Hmm, there was something wrong in my utf-8 cluster setup, I
>> re-attached it and now see that isspace indeed fails:
>> LOG:  plpgsql_convert_ident: ident=3D=C8, isspace array=3Dft, isspace(0)=
=3Df
>
> Hm.  Given that we've not seen this reported elsewhere, I wonder if we
> shouldn't conclude that it's a FreeBSD bug.
>
> We could fix the problem by not using isspace() but some homegrown
> equivalent ... but that seems a tad ugly, especially if it's to work
> around a problem on just one locale on one platform.  Can anyone else
> check the result of isspace(0x85) ?
>
>             regards, tom lane
>
> ---------------------------(end of=20=20
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

Douglas Toltzman
doug@oakstreetsoftware.com
(910) 526-5938

pgsql-bugs by date:

Previous
From: Victor Snezhko
Date:
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Next
From: Tom Lane
Date:
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale