Re: pgAdmin III Query Tool bug

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: "Andrew" <archa(at)pacific(dot)net(dot)au>, "Dave Page" <dpage(at)postgresql(dot)org>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: pgAdmin III Query Tool bug
Date: 2008-01-08 05:25:58
Message-ID: 0c2601c851b6$f350ddc0$c601a8c0@HP22720319231
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers pgadmin-support

Hi.

Please see,
http://winpg.jp/~saito/pgAdmin/QueryTool_check/
It is necessary to set reading and writing of an option to UTF-8.
Although ANSI and UTF-8 are possible as for reading, the option
is required for writing.

Regards,
Hiroshi Saito

----- Original Message -----
From: "Andrew" <archa(at)pacific(dot)net(dot)au>

As the attachment did not appear to make it through, the actual SQL that
causes the 0 byte save is as follows:

DROP TABLE IF EXISTS bad_data;
CREATE TABLE bad_data (
id int NOT NULL,
bad_data varchar(50) NOT NULL,
PRIMARY KEY (id)
);

INSERT INTO bad_data (id, bad_data) VALUES
(1, 'Dhabīḥah'),
(2, 'ذَبِيْحَة');

Cheers,

Andy

---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at

http://www.postgresql.org/about/donate

In response to

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Andrew 2008-01-08 07:19:22 Re: pgAdmin III Query Tool bug
Previous Message Andrew 2008-01-08 03:34:36 Re: pgAdmin III Query Tool bug

Browse pgadmin-support by date

  From Date Subject
Next Message Andrew 2008-01-08 07:19:22 Re: pgAdmin III Query Tool bug
Previous Message Andrew 2008-01-08 03:34:36 Re: pgAdmin III Query Tool bug