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
---(end of broadcast)---
TIP 8: explain analyze is your friend