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

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

From: Victor Snezhko <snezhko(at)indorsoft(dot)ru>
To: Volkan YAZICI <yazicivo(at)ttnet(dot)net(dot)tr>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Date: 2006-09-06 08:12:34
Message-ID: u7j0hv2fh.fsf@indorsoft.ru (view raw or flat)
Thread:
Lists: pgsql-bugspgsql-tr-genel
Victor Snezhko <snezhko(at)indorsoft(dot)ru> writes:

> ERROR:  expected dot between identifiers: х
> CONTEXT:  compile of PL/pgSQL function "createoraltertable" near line 2
>
> the following query fails:
>
> CREATE OR REPLACE FUNCTION TestFunction()
> RETURNS int
> AS $$
> BEGIN
>   SELECT х FROM test_table;
>   RETURN 0;
> END;
> $$ LANGUAGE plpgsql;

Hmm, seems like plpgsql is also broken for multibyte encodings. it
contains some single-byte ops, like the following:

	while (*s && isspace((unsigned char) *s))
		s++;
	if (*s++ != '.')
		elog(ERROR, "expected dot between identifiers: %s", sstart);

If we state that there are fixes for multibyte encodings in 8.2, we
should note that plpgsql is still broken. Being unfamiliar with
postgresql multibyte internals, I don't see a simple way to fix it
now. 

-- 
WBR, Victor V. Snezhko
E-mail: snezhko(at)indorsoft(dot)ru



In response to

Responses

pgsql-tr-genel by date

Next:From: Tom LaneDate: 2006-09-06 13:31:35
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Previous:From: Tom LaneDate: 2006-09-05 14:35:37
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-09-06 13:31:35
Subject: Re: BUG #1931: ILIKE and LIKE fails on Turkish locale
Previous:From: Albe LaurenzDate: 2006-09-06 07:20:38
Subject: Re: [PATCHES] BUG #2600: dblink compile with SSL missing libraries

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