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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Victor Snezhko <snezhko(at)indorsoft(dot)ru>
Cc: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Date: 2006-09-07 04:36:32
Message-ID: 29228.1157603792@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-tr-genel
Victor Snezhko <snezhko(at)indorsoft(dot)ru> writes:
> But... maybe I misunderstand something fundamental, but should isspace
> work when we pass one byte of multibyte character?

Yes, it should, because we only allow ASCII-superset encodings inside
the backend.  That is, characters that actually occupy multiple bytes
must have the high bit set in each such byte, and we expect that
isspace, isdigit, etc will not return true for any such byte.

			regards, tom lane

In response to

pgsql-tr-genel by date

Next:From: Volkan YAZICIDate: 2006-09-07 07:07:38
Subject: Re: Cursor ve Subselect yada Join...
Previous:From: Victor SnezhkoDate: 2006-09-07 04:32:39
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale

pgsql-bugs by date

Next:From: Nimesh SatamDate: 2006-09-07 10:31:34
Subject: Template0 age is increasing speedily.
Previous:From: Victor SnezhkoDate: 2006-09-07 04:32:39
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale

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