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

[MORIYAMA Masayuki]

$B?9;3$G$9!#(B

searover ＠ mail.goo.ne.jp wrote:
> (1) Windows$B4D6-2<$G(B
> ODBC PostgreSQL Driver ANSI ver8.02.04 $B!\(B Access2000
> $B$G$OI=<(!V|b!W(B

Windows $B$N5!<o0MB8J8;z$G!V$O$7$49b!W(B(IBM$B3HD%J8;z(B)$B$G$9$M!#(B
$BHsI8=`$J$N$G!"7zA0>e$OJ8;z2=$1$7$F$bJ86g$O8@$($J$$J8;z$H?4F@$F$*$/I,MW$,(B
$B$"$j$^$9!#(B

$B$=$&$O$$$C$F$b!"B?$/$N%=%U%H$G8BDjE*$J$,$i%5%]!<%H$7$F$$$k$N$G!"$=$l$@$1(B
$B;H$&<{MW$,$"$k$H$$$&;v$J$N$G$7$g$&!#7zA0>e;H$C$F$O$$$1$J$$$H$$$&;v$b$"(B
$B$j!">pJs$,>/$J$/$G$9$M!#;H$$$3$J$9$K$O!"$=$l$J$j$NCN<1$,I,MW$G$9!#(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)

Windows $B>e$GF0:n$9$k(B SSH $B%/%i%$%"%s%"%s%H$G(B Windows $B5!<o0MB8J8;z$,I=<($G(B
$B$-$k$N$O!"(BSJIS$BId9f2=J}<0$N(B CP932 $B$H(B UTF-8 $B$@$1$H9M$($F$*$/$Y$-$G$9!#(B

FreeBSD $B$K(B cocot $B$r%$%s%9%H!<%k$7$F(B PostgreSQL $B$N(B EUC_JP(eucJP-open) $B$D(B
$B$^$j(B eucJP-ms $B$r(B CP932 $B$KJQ49$7$F!"(BSSH $B%/%i%$%"%s%H$O(B SJIS $B$N ＠ _Dj$K$9$k(B
$B$H!"J8;z2=$1$;$:$KI=<($5$l$k2DG=@-$O$"$j$^$9!#(B

$B$3$s$J46$8(B: $ cocot -p eucJP-ms -t cp932 /bin/bash

cocot - COde COnverter on Tty
http://iwa.ath.cx/software/cygwin/cocot.html

FreeBSD $B$N(B iconv(3) $B$,!"(Blibiconv $B$r;H$C$F$$$k$N$G$"$l$P!"(B
ports/converters/libiconv $B$r!V(Bmake WITH_EXTRA_PATCHES=yes$B!W$7$F%$%s%9(B
$B%H!<%k$9$kI,MW$,$"$k$G$7$g$&!#(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)

PHP $B$G(B Windows $B5!<o0MB8J8;z$r07$&$K$O!"(BSJIS $B$H(B EUC-JP $B$G$O$J$/!"(BSJIS-win
$B$H(B eucJP-win $B$r;H$&I,MW$,$"$j$^$9!#(BeucJP-win $B$O!"(BeucJP-ms $B$N;v$J$N$G(B
PostgreSQL $B$N(B EUC_JP $B$r ＠ 5$7$/(B SJIS-win $B$KJQ49$G$-$k$b$N$H;W$o$l$^$9!#(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

Windows $B>e$N%=%U%H$G$N(B EUC-JP $BBP1~$O!"(BCP51932 $B$b$7$/$O(B CP51932 $B%b%I%-$N(B
$B$b$N$7$+$J$$$h$&$K;W$$$^$9!#$3$l$O!"(BPostgreSQL $B$N(B EUC_JP (eucJP-open,
eucJP-ms) $B$H$O8_49 ＠ -$,$"$j$^$;$s!#(B

FreeBSD/Linux $B>e$N%F%-%9%H%(%G%#%?$N>l9g!"(BUnicode $B0J30$O!"$=$b$=$b(B
Windows $B5!<o0MB8J8;z$KBP1~$7$F$$$J$$$s$8$c$J$$$@$m$&$+!D(B

$B%F%-%9%H%(%G%#%?$G(B PostgreSQL $B$N(B EUC_JP$B!"$D$^$j(B eucJP-ms $B$O07$($J$$$H9M(B
$B$($F$*$$$?J}$,$$$$$G$7$g$&!#(B

$B$H$$$&;v$G!"(BEUC$BId9f2=J}<0$O!"5!<o0MB8J8;z$r07$$$@$9$HESC<$KLLE]$K$J$k$N(B
$B$G!"$$$C$=$N;v!"(BUTF-8 $B$K0\9T$7$?J}$,$7$?J}$,9,$;$K$J$l$k$+$b$7$l$^$;$s!#(B

--
$B?9;3(B $B>-G7(B