On 8/30/08, Adrian Klaver <[EMAIL PROTECTED]> wrote: > > Might also be useful to do SHOW ALL from within the database cluster you have > on your restore machine. Will show what choices initdb made. > > test=# SHOW all; > <Snip> > lc_collate | en_US.UTF-8 > lc_ctype | en_US.UTF-8 > lc_messages | en_US.UTF-8 > lc_monetary | en_US.UTF-8 > lc_numeric | en_US.UTF-8 > lc_time | en_US.UTF-8 > <Snip>
Thanks. I did this and LC_COLLATE etc have the values "C". How can I change this to UTF8? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
