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
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
