Re: [BUGS] Degrade(character conversion problem) pga3?

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(at)pse-consulting(dot)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
>