Обсуждение: Re: [pgadmin-hackers] Degrade(character conversion problem) pga3?

Hiroshi Saito wrote:

>Hi Andreas.
>
>I have a problem.
>It is a happening within this week.
>
>See below.
>http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20030922_1.jpg
>http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20031007_1.jpg
>
>Tonight, let me know it if you know something though it will be examined.
>Thank you.
>
>
>

Hi Hiroshi,

AFAICS this is a backend problem. I re-posted this on pgsql-bugs too,
the attached log is your's, reduced to the relevant part. Please check
the query in the Query Tool, try to modify the column name which seems
to provoke this problem.
Maybe you found a bug in the EUC_JP <-> UTF-8 conversion.

Regards,
Andreas

2003-10-09 01:25:27 QUERY  : Set query (128.77.50.202:5432): SELECT null_frac AS "Null Fraction", avg_width AS "Average
Width",n_distinct AS "Distinct Values", most_common_vals AS "Most Common Values", most_common_freqs AS "Most Common
Frequencies",histogram_bounds AS "Histogram Bounds", correlation AS "Correlation" 
  FROM pg_stats
 WHERE schemaname = 'public'
   AND tablename = 'stimsdb'
   AND attname = '要素識別番'
2003-10-09 01:25:27 QUERY  : WARNING:  UtfToLocal: could not convert UTF-8 (0xca94). Ignored
2003-10-09 01:25:27 QUERY  : WARNING:  UtfToLocal: could not convert UTF-8 (0xd427). Ignored
2003-10-09 01:25:27 QUERY  : WARNING:  LocalToUtf: could not convert (0x9776) EUC_JP to UTF-8. Ignored
2003-10-09 01:25:27 QUERY  : WARNING:  LocalToUtf: could not convert (0x9166) EUC_JP to UTF-8. Ignored
2003-10-09 01:25:27 QUERY  : WARNING:  LocalToUtf: could not convert (0x9522) EUC_JP to UTF-8. Ignored
2003-10-09 01:25:27 ERROR  : ERROR:  parser: unterminated quoted string at or near "'・ｯ at character 351

Hi Andreas.

Hmm..
It is thought still to be bug on this side.
Or, wxWindows.
When the code is analyzed, it seems to be the below.

With the SJIS
9776 9166 8eaf 95ca 94d4

With the EUC_JP
d7cd  c7c1 b1bc ccca d6c8

With the UNICODE
feff 8981 7d20 8b58 5225 756a

When it is probably delivered, it fails the change.

regards,
Hiroshi Saito

----- Original Message -----
From: "Andreas Pflug" <pgadmin@pse-consulting.de>


> Hiroshi Saito wrote:
>
> >Hi Andreas.
> >
> >I have a problem.
> >It is a happening within this week.
> >
> >See below.
> >http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20030922_1.jpg
> >http://cre-ent.skcapi.co.jp/~saito/pgadmin3/20031007_1.jpg
> >
> >Tonight, let me know it if you know something though it will be examined.
> >Thank you.
> >
> >
> >
>
> Hi Hiroshi,
>
> AFAICS this is a backend problem. I re-posted this on pgsql-bugs too,
> the attached log is your's, reduced to the relevant part. Please check
> the query in the Query Tool, try to modify the column name which seems
> to provoke this problem.
> Maybe you found a bug in the EUC_JP <-> UTF-8 conversion.
>
> Regards,
> Andreas
>


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


>
> 2003-10-09 01:25:27 QUERY  : Set query (128.77.50.202:5432): SELECT null_frac AS "Null Fraction", avg_width AS
"Average
Width", n_distinct AS "Distinct Values", most_common_vals AS "Most Common Values", most_common_freqs AS "Most Common
Frequencies", histogram_bounds AS "Histogram Bounds", correlation AS "Correlation"
>   FROM pg_stats
>  WHERE schemaname = 'public'
>    AND tablename = 'stimsdb'
>    AND attname = 'è¦ç´ è­~å^¥ç.ª'
> 2003-10-09 01:25:27 QUERY  : WARNING:  UtfToLocal: could not convert UTF-8 (0xca94). Ignored
> 2003-10-09 01:25:27 QUERY  : WARNING:  UtfToLocal: could not convert UTF-8 (0xd427). Ignored
> 2003-10-09 01:25:27 QUERY  : WARNING:  LocalToUtf: could not convert (0x9776) EUC_JP to UTF-8. Ignored
> 2003-10-09 01:25:27 QUERY  : WARNING:  LocalToUtf: could not convert (0x9166) EUC_JP to UTF-8. Ignored
> 2003-10-09 01:25:27 QUERY  : WARNING:  LocalToUtf: could not convert (0x9522) EUC_JP to UTF-8. Ignored
> 2003-10-09 01:25:27 ERROR  : ERROR:  parser: unterminated quoted string at or near "'ãf»ï½¯ at character 351
>