Re: Changing DB Encodings

Naz Gassiep <naz(at)mira(dot)net> writes:
> Why have I been told that I need to do a re initdb to change the char
> encoding? The man says i can just createdb foodb -E utf8 so why
> would i need to dump/initdb/create/restore? cant i just dump/create/restore?

Are you clear on the difference between encoding and locale?

You can make new databases with whatever encoding you say, but the
server's lc_collate and lc_ctype are frozen at initdb, and it will
not work well to select an encoding that is incompatible with the
locale setting. In practice this means that you can only use multiple
database encodings when you initdb'd in "C" locale; all other locale
settings imply a particular encoding.

Yes, this is pretty annoying. No, it's not easy to fix.

regards, tom lane