How to set UTF8 to query browser of PgAdmin III
Dear Sirs,
I am workink on Windows 2000 with PgAdmin III v. 1.6.2
If I open an sql file created with UTF8 encoding the characters with accent
are not reproduced correctly.
If I open the same file with MS Word or JEdit or also PgAdmin III on Fedora
Core 5 it is all ok.
Note, the file was created on window machine with the same PgAdmin, and was
created correctly (UTF8 encoded).
Client encoding on postgresql.conf is set to UTF8 and checked.
What I have to do to instruct PgAdmin to load correctly UTF8 files?
Thank you in advance.
Domenico
On Mon, 2007-02-12 at 08:17 +0100, dfx wrote:
Dear Sirs,
I am workink on Windows 2000 with PgAdmin III v. 1.6.2
If I open an sql file created with UTF8 encoding the characters with accent
are not reproduced correctly.
If I open the same file with MS Word or JEdit or also PgAdmin III on Fedora
Core 5 it is all ok.
Note, the file was created on window machine with the same PgAdmin, and was
created correctly (UTF8 encoded).Client encoding on postgresql.conf is set to UTF8 and checked.
What I have to do to instruct PgAdmin to load correctly UTF8 files?
Hello
We have 'client_encoding = iso8859-1' in our postgresql.conf to see
properly our 'special' characters when the database is utf8. I suppose
you will have to choose the correct encoding for your language too
insteed of utf8.
--
Rafael Martinez, <r.m.guerrero@usit.uio.no>
Center for Information Technology Services
University of Oslo, Norway
PGP Public Key: http://folk.uio.no/rafael/