Skip site navigation (1) Skip section navigation (2)

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

From: Douglas Toltzman <doug(at)oakstreetsoftware(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Date: 2006-09-22 17:55:14
Message-ID: 6ECC1F64-F98A-493D-B96F-B11A52F95164@oakstreetsoftware.com (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-tr-genel
Mac OS X is based on FreeBSD.  I'm not sure if this is what you want,  
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(at)indorsoft(dot)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=È, isspace array=ft, isspace(0)=f
>
> 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  
> broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings

Douglas Toltzman
doug(at)oakstreetsoftware(dot)com
(910) 526-5938



In response to

pgsql-tr-genel by date

Next:From: Tom LaneDate: 2006-09-22 18:19:18
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Previous:From: Victor SnezhkoDate: 2006-09-22 17:48:11
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale

pgsql-bugs by date

Next:From: Thomas VerchowDate: 2006-09-22 18:13:51
Subject: BUG #2645: pg_restore crashes
Previous:From: Victor SnezhkoDate: 2006-09-22 17:48:11
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group