> What you're looking for is to change the encoding, right, and not the locale? Correct. > You can't change the encoding of a database, but you can use a > different one when you create it - this can be specified in the CREATE > DATABASE statement. That's what I wound up doing. > You can also ask pg_dump to use a specific encoding using the -E > parameter. You can't do it on pg_dumpall, but you can do it if you use > pg_dump. That's good to know. I'm curious why a pg_dumpall from 8.4 followed by a restore in 9.2 caused the character sets to change at all. Was there some change in the default character sets between 8.4 and 9.2? -- Tim Gustafson tjg@xxxxxxxx 831-459-5354 Baskin Engineering, Room 313A -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
