On Wed, Sep 14, 2011 at 03:56:27AM +0200, Craig Ringer wrote:
You can't change the encoding of a database in-place.
Thanks Craig and all the other that responded.
Enjoy your day.
Regards
Johann
--
Johann SpiesTelefoon: 021-808 4699
Databestuurder / Data
Good day,
I have installed postgresql 9.0 on my Debian and thought that restoring
the database would be as simple as psql -f the dump made by 8.4's
pg_dumpall.
However: I get several errors like this:
psql:pgdump.txt.1:4453471: ERROR: character 0xe280a6 of encoding UTF8
has no equivalent in
hi,
the character that is giving you troubles is orizontal ellipsis, this
character does not exists in latin1 encoding, only in utf8, so database you
dumped was utf8 encoded.
i think the fastest way you have to solve the problem is: change the encoding
of the target database you are trying
Hi Johann,
as Giulio pointed out, it seems like the destination database is in
LATIN1 encoding, rather than UTF8. Could you please confirm this?
By reading the little information we have, it seems like you have an
export in UTF8 and you are trying to load it into a LATIN1 database. If
Thanks Giulio and Gabriele,
as Giulio pointed out, it seems like the destination database is in
LATIN1 encoding, rather than UTF8. Could you please confirm this?
That was the case. I deleted one of the databases and recreated it with
as a UTF-8 encoded database and the import went well.
On Tue, 2011-09-13 at 14:47 +0200, Johann Spies wrote:
Thanks Giulio and Gabriele,
as Giulio pointed out, it seems like the destination database is in
LATIN1 encoding, rather than UTF8. Could you please confirm this?
That was the case. I deleted one of the databases and recreated
On 09/13/2011 08:47 PM, Johann Spies wrote:
Thanks Giulio and Gabriele,
as Giulio pointed out, it seems like the destination database is in
LATIN1 encoding, rather than UTF8. Could you please confirm this?
That was the case. I deleted one of the databases and recreated it with
as a