Kent Tong <[EMAIL PROTECTED]> writes: > Does it matter? The encoding provided to initdb is just > a default for the databases to be created in the future.
Yes it does, and you missed the point. I said *locale*, not *encoding*. The LC_COLLATE and LC_CTYPE settings that prevail during initdb are fixed and not alterable without re-initdb. (I agree that this sucks, but that's how it is for now...) Your test program doesn't prove a lot unless you are sure it's executing under the same locale settings as the postmaster is running in. 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