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" <[EMAIL PROTECTED]>
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
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
