Re: UTF-8 encoding failure

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(dot)Schaefer(at)cadcorp(dot)com>
To: "'Hiroshi Saito'" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>; "'Takahiro Itagaki'"
<itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: <pgsql-bugs(at)postgresql(dot)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(at)guitar(dot)ocn(dot)ne(dot)jp]
>> Sent: Friday, March 26, 2010 3:36 PM
>> To: Martin Schäfer; 'Takahiro Itagaki'
>> Cc: pgsql-bugs(at)postgresql(dot)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(dot)Schaefer(at)cadcorp(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>