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