From: | henka(at)cityweb(dot)co(dot)za |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Locale/encoding problem/question |
Date: | 2006-08-04 08:48:17 |
Message-ID: | 63301.196.23.181.69.1154681297.squirrel@support.metroweb.co.za |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Martijn van Oosterhout | 2006-08-04 08:56:23 | Re: LISTEN considered dangerous |
Previous Message | Flemming Frandsen | 2006-08-04 08:24:43 | Re: LISTEN considered dangerous |