Re: [GENERAL] change database encoding without corrupting data (latin9 to utf8)

2007-05-19 Thread Michael Fuhr
On Fri, May 18, 2007 at 02:46:26AM -0700, filippo wrote: > 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 se

[GENERAL] change database encoding without corrupting data (latin9 to utf8)

2007-05-19 Thread filippo
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: