Обсуждение: Re : Character encoding conversion
Mike,
If I were you (actually that's what I did whne I had the same problem), I will convert the pg_dump file from LATIN1 charset to UTF8, then copy back into the new UTF8 database. And all should work fine.
On windows you will find that text editors like TextPad and Scite (which runs on Linux too) will convert the file from LATIN1 to UTF8. On Linux there must be some command line tools, but I don't know them.
I hope this helps.
Have fun,
L@u
The Computing Froggy
If I were you (actually that's what I did whne I had the same problem), I will convert the pg_dump file from LATIN1 charset to UTF8, then copy back into the new UTF8 database. And all should work fine.
On windows you will find that text editors like TextPad and Scite (which runs on Linux too) will convert the file from LATIN1 to UTF8. On Linux there must be some command line tools, but I don't know them.
I hope this helps.
L@u
The Computing Froggy
----- Message d'origine ----
De : Mike Blackwell <maiku41@sbcglobal.net>
À : pgAdmin Support <pgadmin-support@postgresql.org>
Envoyé le : Samedi, 9 Février 2008, 15h22mn 23s
Objet : [pgadmin-support] Character encoding conversion
I have a database which was originally created with LATIN1 encoding.
I'd like to move it to UTF8. The data will load ok (COPY) but I am
getting 'invalid byte sequence for encoding..." messages when accessing
the data.
Is there a way to automatically convert the offending characters, or to
easily locate them in a pg_dump file so they can be converted by hand?
Mike
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
De : Mike Blackwell <maiku41@sbcglobal.net>
À : pgAdmin Support <pgadmin-support@postgresql.org>
Envoyé le : Samedi, 9 Février 2008, 15h22mn 23s
Objet : [pgadmin-support] Character encoding conversion
I have a database which was originally created with LATIN1 encoding.
I'd like to move it to UTF8. The data will load ok (COPY) but I am
getting 'invalid byte sequence for encoding..." messages when accessing
the data.
Is there a way to automatically convert the offending characters, or to
easily locate them in a pg_dump file so they can be converted by hand?
Mike
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail