Alexey Mahotkin <[EMAIL PROTECTED]> writes: > I'm running Postgresql 7.3.4 with ru_RU.UTF-8 locale (with UNICODE > database encoding), and all is almost well, except that UPPER() and > LOWER() seem to ignore locale.
upper/lower aren't going to work desirably in any multi-byte character set encoding. I think Peter E. is looking into what it would take to fix this for 7.5, but at present you are going to need to use a single-byte encoding within the server. (Nothing to stop you from using UTF-8 on the client side though.) regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: 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