Re: UTF-8 encoding failure - Mailing list pgsql-bugs
| From | Hiroshi Saito |
|---|---|
| Subject | Re: UTF-8 encoding failure |
| Date | |
| Msg-id | 2452CA9BC78D4BF8AB52BE95B60A945F@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. 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.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: 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@guitar.ocn.ne.jp] >> Sent: Friday, March 26, 2010 4:35 PM >> To: Martin Schäfer; 'Takahiro Itagaki' >> Cc: pgsql-bugs@postgresql.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.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 >> > >> >> >> > **************************************************************************** > 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: