Locale/encoding problem/question - Mailing list pgsql-general

From henka@cityweb.co.za
Subject Locale/encoding problem/question
Date
Msg-id 63301.196.23.181.69.1154681297.squirrel@support.metroweb.co.za
Whole thread Raw
Responses Re: Locale/encoding problem/question
List pgsql-general
Hello all,

I somehow managed to stuff up the encoding (or locale or something) in a
transfer of a database from one machine to another (also different linux
distribution).

The problem is this:  the origional database was created and populated
with data using whatever default locale/encoding was installed on the
first machine.

Words would appear correctly, as in:  Hoë

After dumping the database and restoring on a different one, the word
incorrectly appears as:  Hoë

Before I do any more damage or waste time, I'd appreciate any ideas or
pointers on correctly performing the initdb -E<encoding>
--locale=<locale>... (or any other ideas on resolving this issue) , before
I try and restore the data again.

Thanks
henk


pgsql-general by date:

Previous
From: Flemming Frandsen
Date:
Subject: Re: LISTEN considered dangerous
Next
From: Martijn van Oosterhout
Date:
Subject: Re: LISTEN considered dangerous