Volkan YAZICI <yazicivo@ttnet.net.tr> writes:
> On Sep 04 02:35, Tom Lane wrote:
>> "Devrim GUNDUZ" <devrim@gunduz.org> writes:
>> > Like the bug report that was submitted a few days ago,
>> > http://archives.postgresql.org/pgsql-bugs/2005-09/msg00233.php
>> > I have the same thing for Turkish locale.
>>=20
>> Would you confirm that this is fixed by my recent commit?
>
> I've made some tests. [AFAICS, below results are applicable for all
> latinN encodings.]
>
> Cluster Locale | client_encoding | upper() | lower() | ILIKE | ~*
> -----------------+-----------------+---------+---------+-------+----
> tr_TR.iso8859-9 | LATIN5 | OK | OK | OK | OK
> tr_TR.iso8859-9 | UTF8 | OK | OK | OK | OK
> tr_TR.UTF-8 | LATIN5 | OK | OK | OK | FAILS
> tr_TR.UTF-8 | UTF8 | OK | OK | OK | FAILS
>
> Looks like regex code needs same modifications done to ILIKE command.
I have applied the patch for like.c: r 1.64 -> r 1.65, to my
postgresql 8.1.4 sources, and ILIKE now, obviously, works for
ru_RU.UTF-8 locale.
I still have a couple of issues, though, not sure if anyone reported
them yet.=20
1) When table or column names are multibyte, they are not displayed by
either psql or pgAdmin. What I see is empty strings instead of
table names. It works with latin table names and with national
table names on single-byte encodings.
2) When I try to create a stored procedure to create table (e.g., for
creating table only if it doesn't already exist), it fails to
compile if i use cyrillic letter "=C8" (unicode id: 0x0445, utf-8
representation is D1 85) with the following weird error:
ERROR: expected dot between identifiers: =C8
CONTEXT: compile of PL/pgSQL function "createoraltertable" near line 2
the following query fails:
CREATE OR REPLACE FUNCTION TestFunction()
RETURNS int
AS $$
BEGIN
SELECT =C8 FROM test_table;
RETURN 0;
END;
$$ LANGUAGE plpgsql;
(the only multibyte symbol is that 0x0445 letter, and it's between
select and from).
Simple create table and select, outside of function, works (except the
first issue).
What can I do to help to debug this?
Should I try the sources from CVS HEAD?
--=20
WBR, Victor V. Snezhko
E-mail: snezhko@indorsoft.ru