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

[Douglas Toltzman]

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 <[EMAIL PROTECTED]> 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 [EMAIL PROTECTED] (910) 526-5938