[pgsql-jp: 38410] 一部のSJIS日本語が文字化けする

[searover ＠ mail.goo.ne.jp]

searover$B$H?=$7$^$9!#(B

FreeBSD 5.4$B>e$N(B PostgreSQL 8.0.13$B$G1?MQ$7$F$$$k(B
EUC_JP$B$N%G!<%?%Y!<%9(B(TEST_DB$B$H$7$^$9(B)$B$K$*$$$F(B
$B!V9b!W$N5l;zBN$H$$$&$N$G$7$g$&$+!V|b!W$H$$$&J8;z$,(B
$B!V(B??$B!W$H$7$F(BSJIS$B=PNO$N(BPHP$B$GI=<($5$l$k$N$G$$$m$$$m$H(B
$BHf3S$7$J$,$i!"D4$Y$F$_$?7k2L!"(B

PostgreSQL$BB&$N(Bpostgresql.conf$B$G!"=i4|@_Dj$N(B
CLIENT_ENCODING$B ＠ _Dj$O%3%a%s%H%"%&%H(B(DB$B$N%(%s%3!<%G%#%s%00MB8(B)
$B$N>uBV$G(B

(1) Windows$B4D6-2<$G(B
ODBC PostgreSQL Driver ANSI ver8.02.04 $B!\(B Access2000
$B$G$OI=<(!V|b!W(B

(2) Windows$B$N(BSSH$B%/%i%$%"%s%H>e$N%3%^%s%I%i%$%s$G$N(B
$BI=<((B(EUC_JP$B=PNO(B)$B$G(B
env PAGER=lv LV="-Oej" psql -d TEST_DB
$B>e5-$N%3%^%s%I$G%W%m%s%W%H$KF~$C$F$+$i(B
SELECT$B$9$k$HI=<(!V(B??$B!W(B ($B"(B>$NJ8;z$O ＠ 5>oI=<((B)

(3) PHP($BI=<((BSJIS,$BFbIt%3!<%I(BSJIS)$B$G$O!"(BSELECT$B8e(B
mb_convert_encoding(value,"SJIS","EUC_JP")$B$GJ8;z%3!<%I(B
$BJQ498e$N(Bprint$BI=<(!V(B??$B!W(B ($B"(B>$NJ8;z$O ＠ 5>oI=<((B)

(4) $B0J2<$N%3%^%s%I$G%@%s%W$7(B
pg_dump -d TEST_DB -Fp > TEST_DB.dump
$B%@%s%W%G!<%?$r(BEUC_JP$BBP1~%(%G%#%?$G$N$>$/$H(B
$BA08e$NJ8;z$,J8;z2=$1$F$$$k>uBV$GI=<((B

$B0J>e$N$H$3$m$^$GD4$Y$?$N$G$9$,!"@5>oI=<($5$l$k2r7h:v(B
$B$,$_$D$+$j$^$;$s!#$J$*%G!<%?$NEPO?$O>e5-(B(1)$B4D6-$HF1$8(BAccess
$B>e$+$i9T$C$F$*$j$^$9!#$h$$J}K!$O$J$$$G$7$g$&$+!)(B
$B$465<x$h$m$7$/$*4j$$$$$?$7$^$9!#(B