[pgsql-jp: 26701] Re: Windowsクライアントで正しく表示されない

[M GOTO /BENLINE]

GOTO$B$G$9!#(B

Postgres$B$NFbMF$+$iN%$l$F$-$F$7$^$C$F$$$k$h$&$J5$$,$7$^$9$,!$$5$i$KDI2C$7$^$9!#(B

$BM9JXHV9f(BDB$B$N85%G!<%?$O!$M9@/>J$N:G?7$N$b$N$r(BWindows$B>e$K(BDownload$B$7$F2rE`$7$?$b$N$r(BLinux$B$X(BFTP$B$7$F(B nkf $B$G(B SJIS-->>EUC$BJQ49$r$7$?$b$N$r(B sed $B$GFbMF ＠ 07A$7!$(BPostgres$B>e$G(B \copy --- using delimiters ','   $B$H$7$F(BDB$B$X<h9~$s$@$b$N$G$9!#(B
$B$?$@$3$N(BDB$B$O!$(BSQL_ASCII $B;EMM$G$7$?!#(B

Linux$B>e$N(B psql $B%3%^%s%I%i%$%s$G!J<B:]$O(BTeraTerm$B$NF~NO(B/$B=PNO(BEUC$B!K$G(B

postal=> SELECT * FROM postal WHERE old_code = '100  ' ;

$BEy$H$9$k$H3:Ev$9$kEl5~$NCO0hL>$,I=<($5$l$^$9!#(B
$B$3$N$H$-$N(BDB$B$N(BSQL_ASCII$B;EMM$H$O(BEUC_JP$B$H$I$N$h$&$J4X78$K$J$k$N$G$7$g$&!)(B

>$B?dB,$G$9$,!"$3$N$h$&$J>uBV$@$C$?$N$G$O(B?
> SQL_ASCII$B$J$N$GFbIt=hM}$OL5$7(B($BA4$FL52C9)(B)$B!#(B
> $B$=$N$?$a!"IT ＠ 5$J>uBV(B(Shift-JIS)$B$N$^$^(BDB$B$KEPO?$5$l$F$$$?!#(B
> $B%G!<%?<h$j=P$7;~$bA4$FL52C9)(B($B7k2L$H$7$F(BShift-JIS)$B!#(B
$B$3$N7o$K4X$7$F$O!$@h$K ＠ bL@$7$?$h$&$K(BEUC$B%G!<%?$,M9JXHV9f(BDB$BF~$C$F$$$^$7$?!#(B
$B$3$N$H$-$N(BDB$B$N(BSQL_ASCII$B;EMM$H$O(BEUC_JP$B$H$I$N$h$&$J4X78$K$J$k$N$G$7$g$&!)(B
$B$D$^$j!$(BServlet$B$G$O<+F0%(%s%3!<%G%#%s%0JQ49$7$F$/$l$J$$!$$,!$(BCSE$B$d(BACCESS$B$G$O<+F0JQ49$7$F$/$l$k!#(B
$B$H$j$"$($:!$EvLL$NLdBj$O2r7h$G$-$^$7$?$N$G$3$N$^$^$G$bNI$$$N$G$9$,!#(B

M GOTO
----- Original Message ----- 
From: <h-kato ＠ hokkaido.nsc-kk.co.jp>
To: <pgsql-jp ＠ ml.postgresql.jp>
Sent: Tuesday, July 16, 2002 1:35 PM
Subject: [pgsql-jp: 26700] Re: Windows$B%/%i%$%"%s%H$G ＠ 5$7$/I=<($5$l$J$$(B


$B2CF#$G$9!#(B

> $B$?$@!$LdBj$N$"$C$?(B  SQL_ASCII $B$NM9JXHV9f(BDB$B$G$b%^%$%/%m$N(BACCESS$B$+$i(B
> ODBC$B@\B3$r9T$C$F$$$?$H$-!$$^$?!$%7%'%"%&%(%"$N(BSCE$B$G(BWINDOWS$BB&$+$i(B
> SELECT$BJ8$N<B9T$r$7$?$H$-$b(BEUC-->>SJIS$B$X$N<+F0%(%s%3!<%G%#%s%0JQ49$,(B
> $B5!G=$7$F$$$^$7$?!#(B
> SQL_ASCII $B$NCf$K(BEUC_JP$B%3!<%I$r<h9~$`$H2?$+FCJL$JFbIt=hM}$,9T$o$l$k$N(B
> $B$G$7$g$&$+!#(B

$B?dB,$G$9$,!"$3$N$h$&$J>uBV$@$C$?$N$G$O(B?
 SQL_ASCII$B$J$N$GFbIt=hM}$OL5$7(B($BA4$FL52C9)(B)$B!#(B
 $B$=$N$?$a!"IT ＠ 5$J>uBV(B(Shift-JIS)$B$N$^$^(BDB$B$KEPO?$5$l$F$$$?!#(B
 $B%G!<%?<h$j=P$7;~$bA4$FL52C9)(B($B7k2L$H$7$F(BShift-JIS)$B!#(B

# $B$?$^$?$^%/%i%$%"%s%H$N%3!<%I$,F1$8$J$N$G!"0l8+ ＠ 5>o$K8+$($?$N$G$7$g$&!#(B
# $B$G$b(BServlet(Java$B$J$N$G!"FbIt$G$O(BUTF-8$B$+$J(B?)$B$G$O8+;v$KJ8;z2=$1$7$?$N(B
# $B$G$7$g$&$M(B..
# $BJ8;z%3!<%I$C$F?'!9$J7P0^$,M-$k$N$G!"A4$F<+F0=hM}$5$l$F$k$H;W$$9~$`$H(B
# $B$+$J$j4m81$G$O(B?$BNI$/0U<1$7$J$$$HF1$8;v$N7+$jJV$7$K$J$j$^$9!#(B
# Java$B$G$b!"L52C9)$N$?$aI=<($, ＠ 5$7$/I=<($5$l$F$$$k$@$1!*$H$$$&;v$O(B
# $BNI$/M-$kOC$G$9!#(B
# $BNc(B:SJIS <=> Unicode$B$GNI$/LdBj$K$J$k(B"\"$B!"(B"-"$B!"(B"$B!A(B"$BEy$GLdBj$,82:_2=(B..
# WWW$B>e$G8!:w$9$l$P3F<o=P$F$-$^$9!#$=$NCf$N#1$D$G$9$,(B
http://www.microsoft.com/JAPAN/support/kb/articles/jp170/5/59.asp

# $B2CF#(B