igor <[EMAIL PROTECTED]> writes: > Thank u for hint it really helped me - I made initdb with new lc-ctype > and lc-collate > settings : ru_RU:UTF8. > But im still having one question - some functions - lower() and upper() > doesnt work properly . what im doing wrong?
We don't have any support for upper() and lower() in multibyte character encodings, such as UTF8. You need to use a single-byte encoding (and a locale setting to match, of course). Yeah, I know this sucks :-(. I think Peter Eisentraut is looking into fixing it for 7.5. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match