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

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