Re : Character encoding conversion

Поиск
Список
Период
Сортировка
От Laurent ROCHE
Тема Re : Character encoding conversion
Дата
Msg-id 520108.86582.qm@web34404.mail.mud.yahoo.com
обсуждение исходный текст
Список pgadmin-support
Дерево обсуждения
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


----- 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


Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail

В списке pgadmin-support по дате отправления:

Предыдущее
От: Mike Blackwell
Дата:
Сообщение: Apologies...
Следующее
От: Jonatan Wallmander
Дата:
Сообщение: Wrong colors in data view when running inverse color Gnome theme