REGULAR EXPRESSION POSSIBLE PROBLEM - Mailing list pgsql-bugs

From dev
Subject REGULAR EXPRESSION POSSIBLE PROBLEM
Date
Msg-id 200411060240.iA62eH4k011828@mail.gateway.bg
Whole thread Raw
Responses Re: REGULAR EXPRESSION POSSIBLE PROBLEM
List pgsql-bugs
Hi PG team ,
my database is in UNICODE
I try this (with Bulgarian chars):

SELECT 'Тест проба' ~* 'тест' as result

returns FALSE

above query is same as:

SELECT 'Test exam' ~* 'test' as result

retuns TRUE

the only different is that strings are in English


Is there problem with cyrilic?
I tested postgresql server 8.0.0beta-4 in Win32 platform, but I have same
problem in linux/postgresql 7.4.x with UNICODE database.

Thanks in advanced.

regards Antony Raijekov

pgsql-bugs by date:

Previous
From: contact
Date:
Subject: installation according to C:\Applications\cygwin\usr\share\doc\postgresql-7.4.3\FAQ_MSWIN
Next
From: Tom Lane
Date:
Subject: Re: BUG #1306: locale related issue.