case insensitive match in unicode

From: SunWuKung <Balazs(dot)Klein(at)axelero(dot)hu>
To: pgsql-general(at)postgresql(dot)org
Subject: case insensitive match in unicode
Date: 2006-03-27 09:31:17
Message-ID: MPG.1e91cf53b3a5581989692@news.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message JP Glutting 2006-03-27 09:46:18 Bug? was: Re: ERROR: could not convert UTF8 character to ISO8859-1
Previous Message Sumita Chatterjee 2006-03-27 09:25:33 Recovery in PostgreSql