Re: UTF-8 encoding failure - Mailing list pgsql-bugs

From Hiroshi Saito
Subject Re: UTF-8 encoding failure
Date
Msg-id F44DD54F162B41B6A8E8F85275F4AD21@acer08f817a9b5
Whole thread Raw
In response to UTF-8 encoding failure  (Martin Schäfer <Martin.Schaefer@cadcorp.com>)
Responses Re: UTF-8 encoding failure
List pgsql-bugs
Hi.

I think that the locale is not desirable. However, It is not related to this problem.
Can you test without editing this program?
http://winpg.jp/~saito/PGSQL_SJIS/
I think that it passes.

Regards,
Hiroshi Saito

----- Original Message -----
From: "Martin Schäfer" <Martin.Schaefer@cadcorp.com>
To: "'Hiroshi Saito'" <z-saito@guitar.ocn.ne.jp>; "'Takahiro Itagaki'"
<itagaki.takahiro@oss.ntt.co.jp>
Cc: <pgsql-bugs@postgresql.org>
Sent: Friday, March 26, 2010 11:49 PM
Subject: Re: [BUGS] UTF-8 encoding failure


> Hi,
>
> This worked fine, as you can see in the attached result. However, I can see that my
> database has a different locale (English_United Kingdom.1252) from yours (C). Can this
> cause the problem?
>
> Regards,
>
> Martin
>
>> -----Original Message-----
>> From: Hiroshi Saito [mailto:z-saito@guitar.ocn.ne.jp]
>> Sent: Friday, March 26, 2010 3:36 PM
>> To: Martin Schäfer; 'Takahiro Itagaki'
>> Cc: pgsql-bugs@postgresql.org
>> Subject: Re: [BUGS] UTF-8 encoding failure
>>
>> 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.Schaefer@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
>>
> ****************************************************************************
> This email is confidential and may be privileged and should not be used, read
> or copied by anyone who is not the  original intended recipient. If you have
> received this email in error  please inform the sender and delete it from
> your mailbox or any other storage mechanism. Unless specifically stated,
> nothing in this email constitutes an offer by Cadcorp and Cadcorp does not
> warrant that any information contained in this email is accurate.
> Cadcorp cannot accept liability for any statements made which are clearly the
> sender's own and not expressly made on behalf of Cadcorp or one of its agents.
> Please rely on your own virus check. No responsibility is taken by Cadcorp
> for any damage arising out of any bug or virus infection.
> ****************************************************************************
>


--------------------------------------------------------------------------------


>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

pgsql-bugs by date:

Previous
From: Martin Schäfer
Date:
Subject: Re: UTF-8 encoding failure
Next
From: Martin Schäfer
Date:
Subject: Re: UTF-8 encoding failure