Re: BUG #6282: psql.exe cannot recognize specific 2byte SJIS character

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 行)