Skip site navigation (1) Skip section navigation (2)

Re: UTF-8 encoding failure

From: "Hiroshi Saito" <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>
To: Martin Schäfer <Martin(dot)Schaefer(at)cadcorp(dot)com>,"'Takahiro Itagaki'" <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: UTF-8 encoding failure
Date: 2010-03-26 16:54:10
Message-ID: 2452CA9BC78D4BF8AB52BE95B60A945F@acer08f817a9b5 (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi.

Eh, Have I missed something?_?
set Path=%Path%;C:\Program Files\PostgreSQL\8.4\bin;
It is not this.

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: Saturday, March 27, 2010 12:46 AM
Subject: Re: [BUGS] UTF-8 encoding failure


> Can you copy libpq.dll to the same destination please? I linked libpq as a static library 
> into my project.
>
> Martin
>
>> -----Original Message-----
>> From: Hiroshi Saito [mailto:z-saito(at)guitar(dot)ocn(dot)ne(dot)jp]
>> Sent: Friday, March 26, 2010 4:35 PM
>> To: Martin Schäfer; 'Takahiro Itagaki'
>> Cc: pgsql-bugs(at)postgresql(dot)org
>> Subject: Re: [BUGS] 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
>> >
>>
>>
>>
> ****************************************************************************
> 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
> 


In response to

Responses

pgsql-bugs by date

Next:From: Greg SmithDate: 2010-03-26 18:32:45
Subject: Re: Solid State Drives with PG
Previous:From: Merlin MoncureDate: 2010-03-26 16:48:14
Subject: Re: Solid State Drives with PG (was: in RAM DB)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group