Hi. Ahh ok, Would you try this.
C:\home\HIROSHI>"C:\Program Files\PostgreSQL\8.4\bin\psql.exe" -f SJIS_TEST.SQL -p5433 postgres postgres データベ ース一覧 \x96\xBC\x91O | \x8F\x8A\x97L\x8E | \x83G\x83\x93\x83R\x81[\x83f\x83B\x83\x93\x 83O | \x8Fニ構x87\x8F\x87\x8F\x98 | Ctype(\x95マ浬xB7\x89\x89\x8EZ\x8Eq) | \x83A\x 83N\x83Z\x83X\x8C\xA0 ---------------+-------------------+-------------------------------------------- ----+---------------------------+------------------------------------+---------- -------------------- postgres | postgres | UTF8 | C | C | template0 | postgres | UTF8 | C | C | =c/postgr es : postgres= CTc/postgres template1 | postgres | UTF8 | C | C | =c/postgr es : postgres= CTc/postgres (3 行) UTF8 SJIS psql:SJIS_TEST.SQL:5: NOTICE: CREATE TABLE / PRIMARY KEY will create implicit i ndex "漢字テーブル_pkey" for table "漢字テーブル" CREATE TABLE INSERT 0 1 INSERT 0 1 へんかん | どうですか ------------+------------ さいとう | ひろし こんにちは | ひろしです (2 行) DROP TABLE----- Original Message ----- From: "Martin Schäfer" <martin.schae...@cadcorp.com>
Hello Hiroshi-san,The only differences I found between my source file and yours are the file encoding (Unicode/SJIS), different #include-s and different parameters to PQsetdblogin. I had to undo the last two changes to compile and run on my machine. And the changed file encoding made no difference. It still fails on my machine.Regards, Martin
SJIS_TEST.SQL
Description: Binary data
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs