Dear Itagaki-san,
Please, no flames about my bad English.
Sorry for the delay in getting back to you. It seemed that I gave the
insufficient
information about psql.exe error.
For example, there is the following folder structure.
C:\構築フォルダ └A_TBL.sql
Type the folowing command line in a command prompt and I can get the
error message.
C:\>psql --file="構築フォルダ\A_TBL.sql" --dbname=testdb
--output="psql.csv" --n
o-align --tuples-only --field-separator="," --host=localhost --port=5432
--usern
ame=testsuer --no-password
・築フォルダ/A_TBL.sql: No such file or directory
C:\>
With best regards,
K.Ikezawa
(2011/11/02 14:32), Itagaki Takahiro wrote:
> On Wed, Nov 2, 2011 at 09:52,<ikezawa@tjsys.co.jp> wrote:
>> Bug reference: 6282
>> PostgreSQL version: 9.1.1
>> Operating system: Windows XP
>> Description: psql.exe cannot recognize specific 2byte SJIS character
>> Details:
>> psql.exe cannot recognize specific 2byte SJIS characters.
>>
>> These characters have '\'(0x5c) in low byte of 2 Bytes.
>
> Please send reproducible input pattern.
>
> I saw expected results as long as client encoding is set to SJIS:
>
> postgres=# \encoding SJIS
> postgres=# SELECT '表' AS "ソ";
> ソ
> ----
> 表
> (1 行)