Re: Changing Character Sets

On Tue, Feb 12, 2013 at 6:02 PM, Tim Gustafson <tjg(at)ucsc(dot)edu> wrote:
>> 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?

That depends on your platform, but the answer is likely "yes". Or you
had manually specified SQL_ASCII in the 8.4 method. SQL_ASCII
basically means "don't care at all about encodings".

--
Magnus Hagander
Me: http://www.hagander.net/
Work: http://www.redpill-linpro.com/