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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: 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