change database encoding without corrupting data (latin9 to utf8)
От
filippo
Тема
change database encoding without corrupting data (latin9 to utf8)
Дата
Msg-id
1179481586.333004.274420@w5g2000hsg.googlegroups.com
Список
Дерево обсуждения
change database encoding without corrupting data (latin9 to utf8) filippo <filippo2991@virgilio.it>
Re: change database encoding without corrupting data (latin9 to utf8) Michael Fuhr <mike@fuhr.org>
I have a problem to entry data to postgres database (latin9) from my perl/tk application running on windows (utf8). Whenever I try to entry letter with accents, these looks corrupted once stored into database. A workaround is to set client encoding to UTF8 after creating the database connection: $dbh->do(qq/SET client_encoding to 'UTF8'/); To avoid such kind of workaround I'd like to convert the whole database from LATIN9 to UTF8, how can I do it without corrupting the data? Thanks, Filippo
В списке pgsql-general по дате отправления
От: Andrus
Дата: