"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 dealing with case
conversions in multi-byte character sets (such as Unicode).
Is there a Latin-N encoding you could use?
regards, tom lane
---------------------------(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
