Re: [BUGS] REGULAR EXPRESSION POSSIBLE PROBLEM

2004-11-07 Thread Tom Lane
"dev" <[EMAIL PROTECTED]> writes: > 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 regexp stuff is not currently capable of deal

[BUGS] REGULAR EXPRESSION POSSIBLE PROBLEM

2004-11-07 Thread dev
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