Thread: unicode upper and lower functions

I have PostgreSQL 7.3.2 on Mandrake 9.1.
functions lower and upper doesn't convert UTF8 char cases... it just
leave them as thay are. Atleast I have problems with latvian and russian
letters. Database charset is set to UNICODE. Where is the problem and
what I should do?

Lauris

Lauris Buk¨is wrote:
> I have PostgreSQL 7.3.2 on Mandrake 9.1.
> functions lower and upper doesn't convert UTF8 char cases... it just
> leave them as thay are. Atleast I have problems with latvian and
> russian letters. Database charset is set to UNICODE.

Yes, next time please search the archives and you would have seen that
this bug gets reported at least once per week.

> Where is the
> problem and what I should do?

There is not much you can do right now except not using Unicode.  Search
the archives for possible ideas and workarounds.