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

From: 池澤 和憲 <ikezawa(at)tjsys(dot)co(dot)jp>
To: Itagaki Takahiro <itagaki(dot)takahiro(at)gmail(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #6282: psql.exe cannot recognize specific 2byte SJIS character
Date: 2011-11-08 02:47:09
Message-ID: 4EB8982D.7050403@tjsys.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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(at)tjsys(dot)co(dot)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 行)

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Craig Ringer 2011-11-08 05:41:44 Re: BUG #4678: codepage UTF8 crashes psql
Previous Message Susannah Relf 2011-11-07 09:37:22 BUG #4678: codepage UTF8 crashes psql