I got a complain from a user. If current locale is SJIS, psql does not set client encoding to SJIS.
# localedef -f SHIFT_JIS -i ja_JP /usr/lib/locale/ja_JP.SJIS $ export LANG=ja_JP.SJIS $ psql \encoding SQL_ASCII <-- This should be SJIS This is because the encoding map (encoding_match_list) in chklocale.c is lacking the definition for SHIFT_JIS. Included is a proposed patch. If there's no objection, I will commit it. Best regards, -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp
diff --git a/src/port/chklocale.c b/src/port/chklocale.c index 8b8862f..3c9d7ab 100644 --- a/src/port/chklocale.c +++ b/src/port/chklocale.c @@ -162,6 +162,7 @@ static const struct encoding_match encoding_match_list[] = { {PG_SJIS, "SJIS"}, {PG_SJIS, "PCK"}, {PG_SJIS, "CP932"}, + {PG_SJIS, "SHIFT_JIS"}, {PG_BIG5, "BIG5"}, {PG_BIG5, "BIG5HKSCS"},
-- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers