case insensitive match in unicode - Mailing list pgsql-general

From SunWuKung
Subject case insensitive match in unicode
Date
Msg-id MPG.1e91cf53b3a5581989692@news.postgresql.org
Whole thread Raw
Responses Re: case insensitive match in unicode  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
I would need to do case insensitive match against a field that contains
text in different languages - Greek, Hungarian, Arabic etc.
The db encoding is UTF8.

So far I found no way to achieve that. I tried converting both strings
to the same case and using ~* , but neither worked.

Does anybody no a way to do this?

Thanks for the help.
Balázs

pgsql-general by date:

Previous
From: "Alex bahdushka"
Date:
Subject: Re: PANIC: heap_update_redo: no block
Next
From: JP Glutting
Date:
Subject: Bug? was: Re: ERROR: could not convert UTF8 character to ISO8859-1