Karsten Hilbert wrote:
Just to clarify: lower() on both sides of a comparison should still work as expected on multibyte encodings ? It's been suggested here before.
lower() on both sides also does not working in my case, it still search for case-sensitive data. String in this example have first char capitalized, and result is the same. Seems that lower() can't lower multibyte character.
db=> select lower('Зелен');
lower
-------
Зелен
(1 запись)
--
alexander lunyov
lan@xxxxxxxxxxxx
