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: