Re: [GENERAL] How to set UTF8 to query browser of PgAdmin III

2007-02-12 Thread Rafael Martinez, Guerrero 
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, [EMAIL PROTECTED]
Center for Information Technology Services
University of Oslo, Norway

PGP Public Key: http://folk.uio.no/rafael/


---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
   subscribe-nomail command to [EMAIL PROTECTED] so that your
   message can get through to the mailing list cleanly

[GENERAL] How to set UTF8 to query browser of PgAdmin III

2007-02-11 Thread dfx 
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


---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq