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

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>
To: Victor Snezhko <snezhko@indorsoft.ru>
Cc: Volkan YAZICI <yazicivo@ttnet.net.tr>, pgsql-bugs@postgresql.org
Date: 2006-09-22T16:48:50Z
Lists: pgsql-bugs
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=, 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