granicus.if.org Git - postgresql/blob - doc/README.mb.jp

   1 PostgreSQL 7.3 multi-byte (MB) support README          2002/10/21 \e$B:n@.\e(B
   2
   3                                                         \e$B@P0fC#IW\e(B
   4                                                 ishii@postgresql.org
   5
   6 \e$B"#$O$8$a$K\e(B
   7
   8   PostgreSQL \e$B$K$*$1$k%^%k%A%P%$%H%5%]!<%H$O0J2<$N$h$&$JFCD'$r;}$C$F$$$^$9!%\e(B
   9
  10     1. \e$B%^%k%A%P%$%HJ8;z$H$7$F!$F|K\8l!$Cf9q8l$J$I$N3F9q$N\e(B EUC\e$B!$\e(BUnicode\e$B!$\e(B
  11        mule internal code, ISO-8859-* \e$B$,%G!<%?%Y!<%9:n@.;~$KA*Br2DG=!%\e(B
  12        \e$B%G!<%?%Y!<%9$K$O$3$N%(%s%3!<%G%#%s%0$N$^$^3JG<$5$l$^$9!%\e(B
  13     2. \e$B%F!<%V%kL>$K%^%k%A%P%$%HJ8;z$,;HMQ2DG=\e(B
  14     3. \e$B%+%i%`L>$K%^%k%A%P%$%HJ8;z$,;HMQ2DG=\e(B
  15     4. \e$B%G!<%?$=$N$b$N$K$b%^%k%A%P%$%HJ8;z$,;HMQ2DG=\e(B
  16     5. \e$B%^%k%A%P%$%HJ8;z$N@55,I=8=8!:w$,;HMQ2DG=\e(B
  17     6. \e$B%^%k%A%P%$%HJ8;z$N\e(B LIKE \e$B8!:w$,;HMQ2DG=\e(B
  18     7. character_length(), position(), substring() \e$B$J$I$NJ8;zNs4X?t$G\e(B
  19        \e$B$N%^%k%A%P%$%H%5%]!<%H\e(B
  20     8. \e$B%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0$,%P%C%/%(%s%IB&$H0[$k>l9g$K!$\e(B
  21        \e$B<+F0E*$K%(%s%3!<%G%#%s%0JQ49$r9T$J$$$^$9!%\e(B
  22     9. \e$B%f!<%6Dj5A$N%(%s%3!<%G%#%s%0JQ49$r:n@.2DG=!%\e(B
  23
  24   \e$B%^%k%A%P%$%H%5%]!<%H$,07$&$3$H$N$G$-$k%(%s%3!<%G%#%s%0$O0J2<$K$J$j$^\e(B
  25   \e$B$9!%\e(B
  26
  27         SQL_ASCII       ASCII
  28         EUC_JP          \e$BF|K\8l\e(B EUC
  29         EUC_CN          GB \e$B$r%Y!<%9$K$7$?CfJ8\e(BEUC\e$B!%\e(Bcode set 2 \e$B$O\e(B
  30                         SS2+2\e$B%P%$%H%3!<%I\e(B = 3\e$B%P%$%HI=8=$G$9!%\e(B
  31         EUC_KR          \e$B4Z9q8l\e(B EUC\e$B!%\e(B
  32         JOHAB           \e$B%O%s%0%k%Y!<%9$N4Z9q8l\e(BEUC.
  33         EUC_TW          \e$BBfOQ$N\e(B EUC\e$B!%\e(Bcode set 2 \e$B$O\e(B
  34                         SS2+\e$BLLHV9f\e(B+2\e$B%P%$%H%3!<%I\e(B = 4\e$B%P%$%HI=8=$G$9!%\e(B
  35         UNICODE         UTF-8\e$B!%$?$@$7%5%]!<%H$9$k$N$O\e(B UCS-2 \e$B$NHO0O!$\e(B
  36                         \e$B$9$J$o$A\e(B 0xffff \e$B$^$G$G$9!%\e(B
  37         MULE_INTERNAL   mule \e$B$NFbIt%3!<%I!%$?$@$7!$\e(BType N \e$B$NITDjD9J8;z$O\e(B
  38                         \e$B%5%]!<%H$7$F$$$^$;$s!%\e(B
  39         LATIN1 \e$B$+$i\e(B LATIN10\e$B$^$G\e(B
  40         ISO_8859_1 \e$B$+$i\e(B 16\e$B$^$G\e(B
  41         \e$B%-%j%kJ8;z\e(B        KOI8(KOI8-R), WIN(CP1251), ALT(CP866)\e$B$r%5%]!<%H\e(B
  42                         \e$B$7$F$$$^$9!%$b$A$m$s\e(B ISO 8859-5 \e$B$b;HMQ2DG=$G$9!%\e(B
  43                         \e$B$3$N>l9g!$\e(B"LATIN5" \e$B$H$7$F;XDj$7$F2<$5$$!%\e(B
  44         WIN1256         \e$B%"%i%V=t9q8l\e(BWindows\e$BMQ%(%s%3!<%G%#%s%0\e(B.
  45         TCVN            \e$B%Y%H%J%`8l\e(B."ABC"\e$B$d\e(B"VSCII"\e$B$b;HMQ2DG=\e(B.
  46         WIN874          \e$B%?%$8l\e(B.
  47
  48   \e$B%U%m%s%H%(%s%IB&$G$O$5$i$K0J2<$N%(%s%3!<%G%#%s%0$,;HMQ$G$-$^$9!%\e(B
  49
  50         SJIS            \e$B%7%U%H\e(BJIS(MS932\e$B$H$[$\8_49\e(B)
  51         BIG5            \e$BBfOQ$d9a9A$G;HMQ$5$l$F$$$kCf9q8l!%\e(BEUC_TW\e$B$H8_49\e(B
  52                         \e$B@-$,$"$j$^$9!%\e(B
  53         GBK             Windows-936
  54         UHC             Windows-949
  55         WIN1250         Windows-1250
  56         GB18030         GB18030
  57
  58 \e$B"#F|K\8l$r;HMQ$9$k$3$H$N$G$-$k%(%s%3!<%G%#%s%0\e(B
  59
  60   \e$BA*Br$NL\0B$H$7$F$O!$1Q8l$HF|K\8l$7$+;H$o$J$$>l9g$O\e(B EUC_JP(\e$BF1MM$K!$Cf\e(B
  61   \e$B9q8l$7$+;H$o$J$$>l9g$O\e(B EUC_CN... \e$B$J$I$H$J$j$^$9\e(B)\e$B!$$=$NB>$N8@8l$b;H$$$?\e(B
  62   \e$B$$>l9g$O\e(B UNICODE \e$B$b$7$/$O\e(B MULE_INTERNAL \e$B$H$J$k$G$7$g$&!%\e(B
  63
  64   \e$BCm0U!'\e(BMULE_INTERNAL \e$B$rA*$V$H!$$?$/$5$s$NJ8;z=89g$KBP1~$G$-$FJXMx$G$9\e(B
  65   \e$B$,!$@55,I=8=$GJ#?t$NJ8;z=89g$K$^$?$,$k$h$&$JHO0O;XDj\e(B(\e$B$?$H$($P!$\e(B[a-\e$BHO\e(B]
  66   \e$B$H$+!$\e(B[abc\e$BHO0O\e(B]\e$B$N$h$&$J\e(B)\e$B$O;H$($^$;$s!%J#?t$NHO0O;XDj$G0[$J$kJ8;z=89g\e(B
  67   \e$B$r;H$&$N$O9=$$$^$;$s\e(B(\e$B$?$H$($P\e(B [abc][\e$BHO\e(B-\e$B0O\e(B])\e$B!%$^$?!$\e(B[^a] \e$B$N$h$&$JI=8=\e(B
  68   \e$B$O!$\e(B"a" \e$B$NB0$9$kJ8;z=89g\e(B(\e$B$3$N>l9g!$\e(BUS-ASCII)\e$B$K$*$$$F\e(B "a" \e$B0J30$G$"$k\e(B
  69   \e$B$3$H$rI=$7$^$9!%7h$7$F4A;z$dJ?2>L>$J$I\e(B "a" \e$B0J30$r$9$Y$FI=$9$o$1$G$O\e(B
  70   \e$B$J$$$3$H$KCm0U$7$F2<$5$$!%\e(B
  71
  72 \e$B"#%$%s%9%H!<%k\e(B
  73
  74   PostgreSQL 7.3\e$B$+$i$O\e(Bconfigure\e$B$N%*%W%7%g%s;XDj$NM-L5$K4X$o$i$:!$%^%k\e(B
  75   \e$B%A%P%$%H%5%]!<%H$,M-8z$K$J$C$F$$$^$9$N$G!$FC$K\e(Bconifgure\e$B;~$K%^%k%A%P\e(B
  76   \e$B%$%HMQ$NFCJL$J%*%W%7%g%s$r;XDj$9$kI,MW$O$"$j$^$;$s!%\e(B
  77
  78 \e$B"#\e(Binitdb/createdb/create database \e$B$K$*$1$k%(%s%3!<%G%#%s%0$N;XDj$K$D$$$F\e(B
  79
  80   initdb \e$B$G$O0J2<$N%*%W%7%g%s$G%(%s%3!<%G%#%s%0$,;XDj$G$-$^$9!%\e(B
  81
  82         -E \e$B%(%s%3!<%G%#%s%0\e(B
  83         --encoding=\e$B%(%s%3!<%G%#%s%0\e(B
  84
  85   \e$B$3$3$G;XDj$7$?%(%s%3!<%G%#%s%0$O!$0J8e\e(B createdb/create database \e$B$G%(\e(B
  86   \e$B%s%3!<%G%#%s%0$r>JN,$7$?>l9g$K@_Dj$5$l$k%(%s%3!<%G%#%s%0$K$J$j$^$9!%\e(B
  87   -E \e$B$^$?$O\e(B --encoding \e$B%*%W%7%g%s$r>JN,$7$?>l9g$O!$%(%s%3!<%G%#%s%0$H\e(B
  88   \e$B$7$F\e(BSQL_ASCII\e$B$,:NMQ$5$l$F$7$^$&$N$G!$F|K\8l$r%G%U%)%k%H$G;HMQ$9$k>l\e(B
  89   \e$B9g$O!$\e(B
  90
  91         -E EUC_JP
  92
  93    \e$B$"$k$$$O\e(B
  94
  95         --encoding=EUC_JP
  96
  97   \e$B$H$7$FI,$:L@<(E*$K%(%s%3!<%G%#%s%0$r;XDj$7$F$/$@$5$$!%\e(B
  98
  99   \e$B$J$*!$\e(BPostgreSQL 7.3\e$B0J9_%m%1!<%k%5%]!<%H$,I,$:M-8z$K$J$C$F$$$^$9$,!$\e(B
 100   \e$B$3$l$OF|K\8l$J$I$r;HMQ$9$k:]$K$O2?$N%a%C%j%H$b$J$$$P$+$j$G$J$/!$>c32\e(B
 101   \e$B$N860x$K$J$C$?$j!$\e(BLIKE\e$B8!:w$d@55,I=8=8!:w$G%$%s%G%C%/%9$,M-8z$K$J$i$J\e(B
 102   \e$B$$$J$I$NLdBj$r0z$-5/$3$9$N$G!$L58z$K$7$F$*$/$3$H$r$*$9$9$a$7$^$9!%%m\e(B
 103   \e$B%1!<%k%5%]!<%H$rL58z$K$9$k$?$a$K$O!$\e(B
 104
 105         --no-locale
 106
 107   \e$B%*%W%7%g%s$r;XDj$7$^$9!%\e(B
 108
 109   createdb \e$B$G$O0J2<$N%*%W%7%g%s$G%(%s%3!<%G%#%s%0$,;XDj$G$-$^$9!%\e(B
 110
 111         -E \e$B%(%s%3!<%G%#%s%0\e(B
 112         --encoding=\e$B%(%s%3!<%G%#%s%0\e(B
 113
 114   create database \e$B$G$O0J2<$N%*%W%7%g%s$G%(%s%3!<%G%#%s%0$,;XDj$G$-$^$9!%\e(B
 115
 116         CREATE DATABASE dbanme WITH ENCODING = '\e$B%(%s%3!<%G%#%s%0\e(B';
 117
 118   LOCATION \e$B$rF1;~$K;XDj$9$k>l9g$O0J2<$N$h$&$K$J$j$^$9!%\e(B
 119
 120         CREATE DATABASE dbanme WITH LOCATION = 'path' ENCODING = '\e$B%(%s%3!<%G%#%s%0\e(B';
 121
 122   createdb/create database \e$B$G$O!$%(%s%3!<%G%#%s%0;XDj$r>JN,$7$?>l9g$O!$\e(Binitdb
 123   \e$B$G;XDj$7$?%(%s%3!<%G%#%s%0$,:NMQ$5$l$^$9!%$3$l$O!$\e(Binitdb \e$B$,:n@.$9$k\e(B
 124   \e$B%F%s%W%l!<%H%G!<%?%Y!<%9\e(B(template1)\e$B$N\e(B encoding \e$B%"%H%j%S%e!<%H$r7Q>5\e(B
 125   \e$B$9$k$+$i$G$9!%\e(B
 126
 127   \e$B%G!<%?%Y!<%9$N%(%s%3!<%G%#%s%0$O!$\e(Bpsql -l\e$B!$\e(Bpsql \e$B$N\e(B \l \e$B$G;2>H$G$-$^$9!%\e(B
 128
 129 $ psql -l
 130             List of databases
 131    Database    |  Owner  |   Encoding
 132 ---------------+---------+---------------
 133  euc_cn        | t-ishii | EUC_CN
 134  euc_jp        | t-ishii | EUC_JP
 135  euc_kr        | t-ishii | EUC_KR
 136  euc_tw        | t-ishii | EUC_TW
 137  mule_internal | t-ishii | MULE_INTERNAL
 138  regression    | t-ishii | SQL_ASCII
 139  template1     | t-ishii | EUC_JP
 140  test          | t-ishii | EUC_JP
 141  unicode       | t-ishii | UNICODE
 142 (9 rows)
 143
 144 \e$B"#J8;z7?$N%G!<%?7?$K$D$$$F\e(B
 145
 146   7.2\e$B$G$O!$\e(BCHAR(n)\e$B$H\e(BVARCHAR(n)\e$B$N\e(B n \e$B$OJ8;z?t$r0UL#$7$^$9!%\e(Bn \e$B$,%P%$%H?t$r\e(B
 147   \e$B0UL#$9$k\e(B 7.1 \e$B0JA0$H$O0[$J$j$^$9$N$G$4Cm0U2<$5$$!%\e(B
 148
 149   \e$BNc$r<($7$^$9!%\e(B
 150
 151   7.2\e$B$G$O!$\e(BCHAR(1)\e$B$K\e(B"\e$B$"\e(B"\e$B$r3JG<$G$-$^$9$,!$\e(B7.1\e$B0JA0$G$O3JG<$G$-$^$;$s$3\e(B
 152   \e$B$l$O!$\e(B"\e$B$"\e(B"\e$B$r3JG<$9$k$?$a$K>/$J$/$H$b\e(B2\e$B%P%$%H0J>e$rMW$9$k$+$i$G$9!%\e(B
 153   \e$B5U$K!$\e(B"a" \e$B$O\e(B1\e$B%P%$%H$7$+>CHq$7$J$$$?$a!$\e(B7.1\e$B$G$b\e(B CHAR(1) \e$B$K3JG<$G$-$^\e(B
 154   \e$B$9!%\e(B
 155
 156   \e$B$J$*!$\e(B7.2\e$B$G$O!$\e(B7.1\e$B$^$G$H0[$J$j!$\e(BCHAR(n)\e$B$K3JG<$G$-$J$$\e(B n \e$BJ8;z$h$jBg$-\e(B
 157   \e$B$$J8;zNs$O\e(B n \e$BJ8;z$G@Z$j<N$F$i$l$k$N$G$O$J$/!$%(%i!<$K$J$k$3$H$K$4Cm\e(B
 158   \e$B0U2<$5$$!%$3$l$O!$%^%k%A%P%$%HBP1~$NM-L5$K4X$o$i$:!$J8;zNs$N07$$$,\e(B
 159   SQL\e$BI8=`$K1h$&$h$&$KJQ$C$?$+$i$G$9!%\e(B
 160
 161 \e$B"#%U%m%s%H%(%s%I$H%P%C%/%(%s%I$N<+F0%(%s%3!<%G%#%s%0JQ49$K$D$$$F\e(B
 162
 163   \e$B%P%C%/%(%s%I\e(B(\e$B%G!<%?%Y!<%9\e(B)\e$B$H\e(B psql \e$B$J$I$N%U%m%s%H%(%s%I$N%(%s%3!<%G%#\e(B
 164   \e$B%s%0$O0lCW$7$F$$$k$N$,86B'$G$9$,!$$$$/$D$+$N%(%s%3!<%G%#%s%0$K$D$$$F\e(B
 165   \e$B$O%P%C%/%(%s%I$H%U%m%s%H%(%s%I$N4V$G0[$J$k$b$N$r;HMQ$9$k$3$H$,$G$-$^\e(B
 166   \e$B$9!%$3$N>l9g!$<+F0E*$K%P%C%/%(%s%I$G%(%s%3!<%G%#%s%0JQ49$,9T$o$l$^$9!%\e(B
 167
 168   \e$B%P%C%/%(%s%I$N%(%s%3!<%G%#%s%0\e(B  \e$B5vMF$5$l$k%U%m%s%H%(%s%I$N\e(B
 169                                         \e$B%(%s%3!<%G%#%s%0\e(B
 170   ----------------------------------------------------------------
 171         EUC_JP                          EUC_JP, SJIS, UNICODE
 172
 173         EUC_TW                          EUC_TW, BIG5, UNICODE
 174
 175         EUC_CN                          EUC_CN, UNICODE
 176
 177         EUC_KR                          EUC_KR, UNICODE
 178
 179         JOHAB                           JOHAB, UNICODE
 180
 181         LATIN1,3,4                      LATIN1,3,4, UNICODE
 182
 183         LATIN2                          LATIN2, WIN1250, UNICODE
 184
 185         LATIN5                          LATIN5, WIN, ALT, UNICODE
 186
 187         LATIN6,7,8,9,10                 LATIN6,7,8,9,10, UNICODE
 188
 189         ISO_8859_5,6,7,8                ISO_8859_5,6,7,8, UNICODE
 190
 191         WIN1256                         WIN1256, UNICODE
 192
 193         TCVN                            TCVN, UNICODE
 194
 195         WIN874                          WIN874, UNICODE
 196
 197         MULE_INTERNAL                   EUC_JP, SJIS, EUC_KR, EUC_CN,
 198                                         EUC_TW, BIG5, LATIN1\e$B$+$i\e(B5,
 199                                         WIN, ALT, WIN1250
 200
 201         UNICODE                         EUC_JP, SJIS, EUC_KR, UHC,
 202                                         EUC_CN, GBK, EUC_TW, BIG5,
 203                                         LATIN1\e$B$+$i\e(B10, ISO_8859_5\e$B$+$i\e(B8,
 204                                         WIN, ALT, WIN1250, WIN1256,
 205                                         TCVN, WIN874, JOHAB
 206   ----------------------------------------------------------------
 207
 208   \e$B%P%C%/%(%s%I$H%U%m%s%H%(%s%I$N%(%s%3!<%G%#%s%0$,0[$J$k>l9g!$$=$N$3$H\e(B
 209   \e$B$r%P%C%/%(%s%I$KEA$($kI,MW$,$"$j$^$9!%$=$N$?$a$NJ}K!$,$$$/$D$+$"$j$^\e(B
 210   \e$B$9!%\e(B
 211
 212 o psql \e$B$N\e(B \encoding \e$B%3%^%s%I$r;H$&J}K!\e(B
 213
 214   psql\e$B$G$O!$\e(B\encoding\e$B%3%^%s%I$r;H$C$FF0E*$K%U%m%s%H%(%s%IB&$NJ8;z%3!<\e(B
 215   \e$B%I$r@ZBX$($k$3$H$,$G$-$^$9!%Nc\e(B:
 216
 217         \encoding SJIS
 218
 219 o libpq \e$B$N4X?t\e(B PQsetClientEncoding \e$B$r;H$&J}K!\e(B
 220
 221   7.0 \e$B$+$i?7$7$$\e(B libpq \e$B4X?t\e(B PQsetClientEncoding \e$B$,DI2C$5$l$F$$$^$9!%\e(B
 222
 223   PQsetClientEncoding(PGconn *conn, const char *encoding)
 224
 225   \e$B$3$N4X?t$r;H$($P!$%3%M%/%7%g%sKh$K%(%s%3!<%G%#%s%0$r@ZBX$($k$3$H$,$G\e(B
 226   \e$B$-$^$9!%8=:_$N%(%s%3!<%G%#%s%0$NLd$$9g$o$;$O\e(B
 227
 228   int PQclientEncoding(const PGconn *conn)
 229
 230   \e$B$G$9!%\e(B
 231
 232 o postgresql.conf \e$B$G@_Dj$9$kJ}K!\e(B
 233
 234   \e$B%U%m%s%H%(%s%I$N%G%U%)%k%H%(%s%3!<%G%#%s%0$r;XDj$9$k$K$O!$\e(B
 235   postgresql.conf \e$B$N\e(B client_encoding \e$B$r;XDj$7$^$9!%;XDjNc\e(B:
 236
 237   client_encoding = SJIS
 238
 239 o \e$B4D6-JQ?t\e(B PGCLIENTENCODING \e$B$r;H$&J}K!\e(B
 240
 241   (1) postmaster \e$B5/F0;~$K4D6-JQ?t$r@_Dj$9$kJ}K!\e(B
 242
 243   \e$B4D6-JQ?t\e(B PGCLIENTENCODING \e$B$r@_Dj$9$k$3$H$K$h$j!$\e(B postgresql.conf \e$B$G\e(B
 244   \e$B%(%s%3!<%G%#%s%0$r;XDj$9$k$N$HF1$88z2L$,F@$i$l$^$9!%$?$@$7!$$3$l$ONr\e(B
 245   \e$B;KE*7P0^$+$i;D$5$l$F$$$k5!G=$G!$:#8e$O$3$N5!G=$rMxMQ$7$J$$$3$H$r$*$9\e(B
 246   \e$B$9$a$7$^$9!%@_DjNc\e(B:
 247
 248   export PGCLIENTENCODING=SJIS postmaster -S
 249
 250   (2) \e$B%/%i%$%"%s%H!$%U%m%s%H%(%s%IKh$K%(%s%3!<%G%#%s%0$r@_Dj$7$?$$>l9g\e(B
 251
 252   \e$B$=$N%U%m%s%H%(%s%I\e(B(\e$B$?$H$($P\e(B psql)\e$B$r5/F0$9$kA0$K4D6-JQ?t\e(B
 253   PGCLIENTENCODING \e$B$r@_Dj$7$^$9!%\e(B
 254
 255 o set client_encoding \e$B%3%^%s%I$r;H$&J}K!\e(B
 256
 257   SET CLIENT_ENCODING SQL\e$B%3%^%s%I$r;H$C$FF0E*$K%U%m%s%H%(%s%I$N%(%s%3!<\e(B
 258   \e$B%G%#%s%0$rJQ99$G$-$^$9!%Nc\e(B:
 259
 260         SET CLIENT_ENCODING TO SJIS;
 261
 262 \e$B"#8=:_@_Dj$5$l$F$$$k%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0$rD4$Y$k\e(B
 263
 264  \e$B8=:_@_Dj$5$l$F$$$k%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0$O\e(B
 265
 266         show client_encoding;
 267
 268  \e$B$G;2>H$G$-$^$9\e(B(\e$B>.J8;z$GI=<($5$l$^$9\e(B)\e$B!%\e(B
 269
 270 \e$B"#%G%U%)%k%H$N%(%s%3!<%G%#%s%0$X$NI|5"\e(B
 271
 272   SQL\e$B%3%^%s%I\e(B:
 273
 274         RESET CLIENT_ENCODING;
 275
 276   \e$B$O!$%G%U%)%k%H$N%U%m%s%H%(%s%I%(%s%3!<%G%#%s%0@_Dj$KI|5"$5$;$^$9!%\e(B
 277   postmaster\e$B$rN)$A>e$2$k$H$-$K\e(B postgresql.conf \e$B$N\e(B client_encoding \e$B$d4D\e(B
 278   \e$B6-JQ?t\e(B PGCLIENTENCODING \e$B$,@_Dj$5$l$F$$$k$H$=$N%(%s%3!<%G%#%s%0$K!$$=\e(B
 279   \e$B$&$G$J$1$l$P%G!<%?%Y!<%9$N%(%s%3!<%G%#%s%0$HF1$8$K$J$j$^$9!%\e(B
 280
 281 \e$B"#L@<(E*$J%(%s%3!<%G%#%s%0JQ49\e(B
 282
 283   7.2\e$B$G$O!$\e(Bconvert\e$B$H$$$&4X?t$r;H$$!$L@<(E*$J%(%s%3!<%G%#%s%0JQ49$,$G$-\e(B
 284   \e$B$^$9!%\e(B
 285
 286   convert(string text, [src_encoding name,] dest_encoding name)
 287
 288   \e$B$3$3$G\e(Bsrc_encoding\e$B$O\e(Btext\e$B$N%(%s%3!<%G%#%s%0L>$G$9!%>JN,$9$k$H!$%G!<%?\e(B
 289   \e$B%Y!<%9%(%s%3!<%G%#%s%0L>$HF1$8$G$"$k$H8+$J$5$l$^$9!%\e(Bdest_encoding\e$B$O!$\e(B
 290   \e$BJQ498e$N%(%s%3!<%G%#%s%0L>$G$9!%\e(B
 291
 292   \e$BNc$r<($7$^$9!%\e(B
 293
 294   SELECT convert(text, EUC_JP) FROM unicode_tbl;
 295
 296   \e$B$O!$\e(BUnicode\e$B$N%F!<%V%k\e(Bunicode_tbl\e$B$N\e(Btext\e$BNs$r\e(BEUC_JP\e$B$KJQ49$7$FJV$7$^$9!%\e(B
 297
 298   7.3\e$B$G$O$5$i$K\e(BSQL\e$BI8=`$N\e(BCONVERT\e$B4X?t$,;H$($^$9!%\e(BSQL\e$BI8=`$N\e(BCONVERT\e$B$O\e(B
 299   PostgreSQL\e$B$N\e(BCONVERT\e$B$H5!G=$O$[$H$s$IF1$8$G$9$,!$8F$S=P$77A<0$,0[$j$^\e(B
 300   \e$B$9!%\e(B
 301
 302   SELECT convert(text using euc_jp_to_utf8) FROM unicode_tbl;
 303
 304   "using" \e$B$N8e$N0z?t$O!V%3%s%P!<%8%g%sL>!W$G$9!%$3$NNc$G$O!$\e(BEUC_JP \e$B$+\e(B
 305   \e$B$i\e(B UTF-8 \e$B$KJQ49$9$k%3%s%P!<%8%g%s$r;XDj$7$F$$$^$9!%Dj5A:Q$N%3%s%P!<\e(B
 306   \e$B%8%g%s$K$D$$$F$O!$%f!<%6!<%:%,%$%I$N\e(B "String Functions and
 307   Operators" \e$B$NI=\e(B"Built-in Conversions" \e$B$r8+$F$/$@$5$$!%\e(B
 308
 309 \e$B"#%(%s%3!<%G%#%s%0JQ49ITG=$N>l9g$N=hM}\e(B
 310
 311   \e$B%P%C%/%(%s%IB&$N%(%s%3!<%G%#%s%0$H%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0\e(B
 312   \e$B$,$$$D$bAj8_JQ49$G$-$k$H$O8B$j$^$;$s!%6KC<$JOC!$%P%C%/%(%s%IB&$,\e(B
 313   EUC_JP \e$B$J$N$K!$%U%m%s%H%(%s%IB&$,\e(B EUC_KR \e$B$@$C$?$i$I$&$J$k$G$7$g$&!%\e(B
 314   \e$B$3$N>l9g\e(B PostgreSQL \e$B$OJQ49$G$-$J$$%3!<%I$r\e(B 16\e$B?JI=8=$KJQ49$7$^$9!%\e(B
 315   \e$B$?$H$($P!$\e(B"(bdae)" \e$B$N$h$&$K!%$J$*!$$3$N\e(B 16\e$B?JI=8=$O\e(B mule
 316   internal code \e$B$N%3!<%I$G$"$k$3$H$KCm0U$7$F2<$5$$!%$3$l$O!$D>@\%U%m%s\e(B
 317   \e$B%H%(%s%I\e(B <--> \e$B%P%C%/%(%s%I$N%(%s%3!<%G%#%s%0$rJQ49$9$k$N$G$O$J$/!$0l\e(B
 318   \e$BEYFbItI=8=$G$"$k\e(B mule internal code \e$B$r7PM3$7$F$$$k$?$a$G$9!%\e(B
 319
 320   \e$B$J$*!$\e(BUnicode\e$B$H$=$l0J30$N%(%s%3!<%G%#%s%0$NJQ49$@$1$ONc30$G!$\e(BNOTICE
 321   \e$B%a%C%;!<%8$,I=<($5$l!$JQ49ITG=$NJ8;z$OL5;k$5$l$^$9!%\e(B
 322
 323 \e$B"#%G%U%)%k%H%3%s%P!<%8%g%s\e(B
 324
 325   \e$B%G%U%)%k%H%3%s%P!<%8%g%s$O!$%P%C%/%(%s%I$H%U%m%s%H%(%s%I$H$N4V$N%(%s\e(B
 326   \e$B%3!<%G%#%s%0$N<+F0JQ49$K;H$o$l$kFCJL$J%3%s%P!<%8%g%s$G$9!%%G%U%)%k%H\e(B
 327   \e$B%3%s%P!<%8%g%s$O3F!9$N\e(B{\e$B%9%-!<%^!$%=!<%9%(%s%3!<%G%#%s%0!$%G%9%F%#%M!<\e(B
 328   \e$B%7%g%s%(%s%3!<%G%#%s%0\e(B}\e$B$NAH$_9g$o$;$K$*$$$F!$$?$@0l8D$@$1B8:_$7$^$9!%\e(B
 329   \e$B>e5-$G@bL@$7$?AH$_9~$_:Q$N%3%s%P!<%8%g%s$O!$\e(Bpg_catalog\e$B%9%-!<%^$K$*$$\e(B
 330   \e$B$FDj5A$5$l$F$*$j!$%9%-!<%^%5!<%A%Q%9$N@_Dj$K4X$o$i$:I,$:MxMQ$G$-$k%3\e(B
 331   \e$B%s%P!<%8%g%s$K$J$C$F$$$^$9!%\e(B
 332
 333   \e$B5U$K8@$&$H!$\e(B pg_catalog \e$B0J30$N%9%-!<%^$K%G%U%)%k%H%3%s%P!<%8%g%s$r:n\e(B
 334   \e$B@.$9$k$3$H$K$h$j!$%G%U%)%k%H%3%s%P!<%8%g%s$r<+M3$KA*Br$9$k$3$H$b$G$-\e(B
 335   \e$B$k$o$1$G$9!%$?$H$($P\e(B SJIS \e$B$H$NJQ49$K$*$$$F!$\e(BPostgreSQL \e$B$,MQ0U$7$F$$\e(B
 336   \e$B$k\e(B MS932\e$B8_49\e(B \e$B$NJQ49$G$O$J$/!$\e(BJIS \e$B5,3J$N%7%U%H%8%9$KAjEv$9$kJQ49$r9T\e(B
 337   \e$B$&$h$&$J%3%s%P!<%8%g%s$r:n@.$9$k$3$H$b2DG=$G$9!%\e(B
 338
 339 \e$B"#%f!<%6Dj5A%3%s%P!<%8%g%s$N:n@.\e(B
 340
 341   PostgreSQL 7.3\e$B0J9_!$%f!<%6Dj5A$N%3%s%P!<%8%g%s$r:n@.$G$-$k$h$&$K$J$C\e(B
 342   \e$B$F$$$^$9!%%3%s%P!<%8%g%s$NDj5A$O\e(B CREATE CONVERSION \e$B$H$$$&\e(B SQL \e$B%3%^%s\e(B
 343   \e$B%I$r;H$C$F9T$$$^$9!%\e(B
 344
 345     CREATE [DEFAULT] CONVERSION conversion_name
 346         FOR source_encoding
 347         TO dest_encoding FROM funcname
 348
 349   \e$B>\:Y$O%j%U%!%l%s%9%^%K%e%"%k$r$4Mw2<$5$$!%\e(B
 350
 351 \e$B"#\e(BSJIS\e$B%f!<%6Dj5AJ8;z$X$NBP1~\e(B
 352
 353   7.0 \e$B$+$i\e(B SJIS\e$B%f!<%6Dj5AJ8;z\e(B (UDC) \e$B$KBP1~$7$F$$$^$9!%\e(BUDC \e$B$r$I$&07$&$+\e(B
 354   \e$B$H8@$&$3$H$K$D$$$FCf>r$5$s\e(B(nak@email.com)\e$B$+$iLdBjDs5/$H>\:Y$J2r@b$r\e(B
 355   \e$BD:$-$^$7$?$N$G!$;29M$N$?$a$K$3$N%I%-%e%a%s%H$N:G8e$KIU$1$F$*$-$^$9!%\e(B
 356   \e$B$^$?!$$3$NLdBj$K$D$$$F$O!$\e(BPostgreSQL\e$BF|K\8l%a!<%j%s%0%j%9%H$N\e(B
 357   [pgsql-jp 12288] (1999/12/17\e$BIU\e(B)\e$B$H\e(B [pgsql-jp 12486] (2000/1/5\e$BIU\e(B) \e$B$+$i\e(B
 358   \e$B;O$^$k%9%l%C%I$G5DO@$r8+$k$3$H$,$G$-$^$9\e(B(\e$B%a!<%k$N%"!<%+%$%V$O\e(B
 359   http://www.sra.co.jp/people/t-ishii/PostgreSQL/ \e$B$G;2>H$G$-$^$9\e(B)\e$B!%\e(B
 360
 361   \e$B$3$3$G$O!$$=$l$i$N5DO@$r$U$^$(!$4JC1$K2r@b$7$^$9!%\e(B
 362
 363   PostgreSQL\e$B$G$O!$F|K\8l$r;HMQ$9$k:]$K%P%C%/%(%s%IB&$N%(%s%3!<%G%#%s%0\e(B
 364   \e$B$r\e(B EUC_JP \e$B$^$?$O\e(B MULE_INTERNAL or Unicode \e$B$K$9$kI,MW$,$"$j$^$9!%\e(B
 365   MULE_INTERNAL \e$B$O\e(B EUC_JP \e$B$KJ8;z=89g$rI=$9%3!<%I$rIU$1$?$b$N$J$N$G!$K\\e(B
 366   \e$B<AE*$KF1$8$G$9!%$^$?!$\e(BUnicode <---> SJIS \e$BJQ49$O8=:_$N$H$3$m%5%]!<%H\e(B
 367   \e$B$5$l$F$$$^$;$s$N$GL5;k$7$^$9!%$7$?$,$C$F!$$3$3$G$O\e(B EUC_JP \e$B$H\e(B SJIS \e$B$N\e(B
 368   \e$BAj8_JQ49$N$_$r9M$($^$9!%\e(B
 369
 370   \e$BM=HwCN<1\e(B
 371
 372   \e$B0l8}$K\e(B EUC_JP \e$B$H$$$C$F$b!$<B:]$K$OCf?H$OJ#?t$NJ8;z=89g$+$i@.$jN)$C$F\e(B
 373   \e$B$$$^$9!%\e(B
 374
 375         G0: JIS ROMAN (ASCII \e$B$H$[$\F1$8\e(B)
 376         G1: JIS X 0208 (JIS \e$B4A;z\e(B)
 377         G2: JIS X 0201 (1\e$B%P%$%H%+%J\e(B)
 378         G3: JIS X 0212 (JIS \e$BJd=u4A;z\e(B)
 379
 380   \e$B0lJ}\e(B SJIS \e$B$O$3$N$&$A4pK\E*$K\e(B G0, G1, G2 \e$B$r%5%]!<%H$7$F$*$j!$\e(BG3 \e$B$O%5\e(B
 381   \e$B%]!<%H$7$F$$$^$;$s!%$7$?$,$C$F!$\e(BSJIS \e$B$O\e(B EUC_JP \e$B$NItJ,=89g$H$_$J$9$3\e(B
 382   \e$B$H$,$G$-!$<B:]\e(B PostgreSQL 6.5 \e$B$^$G$O$3$N9M$($G<BAu$5$l$F$$$^$7$?!%\e(B
 383
 384   \e$B$H$3$m$,!$\e(BWindows PC \e$B$N\e(B SJIS \e$B$N@$3&$G$O!$>e5-\e(B JIS \e$B5,3J$GDj5A$5$l$F$$\e(B
 385   \e$B$J$$J8;z%3!<%I$,0lItMxMQ$5$l$F$*$j!$$3$NItJ,\e(B (UDC) \e$B$O=>Mh\e(B PostgreSQL
 386   \e$B$G$OA4$/9MN8$5$l$F$$$^$;$s$G$7$?!%<B:]\e(B UDC \e$B$r4^$`\e(B SJIS \e$B$r\e(B EUC_JP \e$B$K\e(B
 387   \e$BJQ49$9$k$H$-$KIT@5$JJQ49$,9T$o$l$F$$$^$7$?!%$=$3$G\e(B PostgreSQL 7.0 \e$B$G\e(B
 388   \e$B$O!$$^$:$3$NLdBj$r2r7h$9$k$3$H$K$7$^$7$?!%\e(B
 389
 390   \e$B$^$?!$\e(BUDC \e$B$NMxMQJ}$K$D$$$F$OI8=`5,3J$N$h$&$J$b$N$O$"$j$^$;$s$,!$<B$O\e(B
 391   \e$B6H3&CDBN$G$N<h$j7h$a$,$"$j!$$$$o$f$k%G%U%!%/%H%9%?%s%@!<%I$J$i$PB8:_\e(B
 392   \e$B$9$k$3$H$,J,$+$j$^$7$?!%$=$3$G$3$l$K$D$$$F$b$G$-$k$@$1%5%]!<%H$9$k$3\e(B
 393   \e$B$H$K$7$^$7$?!%\e(B
 394
 395   PostgreSQL 7.0 \e$B$G$N\e(B UDC \e$BBP1~$N<BAu\e(B
 396
 397   (1) \e$B%f!<%6Dj5AJ8;zNN0h$O\e(B JIS \e$B$N%f!<%6Dj5AJ8;zNN0h$K%^%C%T%s%0$9$k!%\e(B
 398   SJIS \e$B$H\e(B EUC_JP \e$B$G\e(B1\e$BBP\e(B1\e$B$NBP1~$K$J$j$^$9!%\e(B
 399
 400     - SJIS \e$B%f!<%6Dj5AJ8;zNN0h\e(B A (\e$B2>>N\e(B)
 401           95\e$B!A\e(B104 \e$B6h\e(B  \e$B"+"*\e(B \e$BF|K\8l\e(B EUC / G1 (JIS X 0208) 85\e$B!A\e(B95 \e$B6h\e(B
 402
 403     - SJIS \e$B%f!<%6Dj5AJ8;zNN0h\e(B B (\e$B2>>N\e(B)
 404          105\e$B!A\e(B114 \e$B6h\e(B  \e$B"+"*\e(B \e$BF|K\8l\e(B EUC / G3 (JIS X 0212) 85\e$B!A\e(B95 \e$B6h\e(B
 405
 406   (2) IBM \e$B3HD%J8;zNN0h\e(B (SJIS 115\e$B!A\e(B120 \e$B6h\e(B)
 407
 408   \e$BJQ49%F!<%V%k$K$h$C$F\e(B G1 (JIS X 0208)\e$B$H!$\e(BG3 (JIS X 0212)\e$B$KJQ49$5$l$^\e(B
 409   \e$B$9!%$J$*!$$3$NJQ49$K$*$$$F$O!$\e(BSJIS --> EUC_JP \e$B$GJQ49$7!$:F$S\e(B EUC_JP --
 410   > SJIS \e$B$KJQ49$9$k$H85$N\e(B SJIS \e$B$KLa$i$J$$$3$H$,$"$j$^$9!%$^$?!$\e(BEUC_JP --
 411   > SJIS \e$B$NJQ49$G$O!$$9$Y$F$NJ8;z$rJQ49$G$-$k$o$1$G$O$J$$$N$G!$$=$N>l\e(B
 412   \e$B9g$OJQ49ITG=J8;z$H$7$F!V".!W$KCV$-49$($^$9!%\e(B
 413
 414   *\e$B6H3&CDBN$N<h$j7h$a$G$O!$JQ49ITG=J8;z$O!V<BAu0MB8!W$H$J$C$F$$$^$9$,!$\e(B
 415   Solaris \e$B$r$O$8$a!$B?$/$N%7%9%F%`$,!V".!W$rJQ49ITG=J8;z$K:NMQ$7$F$$$^\e(B
 416   \e$B$9!%\e(BPostgreSQL\e$B$b$3$l$K9g$o$;$^$7$?!%\e(B
 417
 418   (3) NEC \e$BA*Dj\e(B IBM \e$B3HD%J8;zNN0h\e(B (SJIS 89\e$B!A\e(B92 \e$B6h\e(B)
 419
 420   PostgreSQL 7.0\e$B$G$O$9$Y$FJQ49ITG=J8;z!V".!W$KCV$-49$($i$l$^$9!%\e(B
 421
 422   PostgreSQL 7.0.1\e$B0J9_$G$O!$0lC6\e(B IBM \e$B3HD%J8;zNN0h$KJQ49$5$l$?8e!$\e(BG1
 423   (JIS X 0208)\e$B$H!$\e(BG3 (JIS X 0212)\e$B$KJQ49$5$l$^$9!%\e(B
 424
 425 \e$B<U<-!'\e(B
 426
 427   o \e$BFA2H\e(B@\e$B;06(1?M"%5!<%S%9$5$s$+$i!$\e(BNEC \e$BA*Dj\e(B IBM \e$B4A;zBP1~%Q%C%A$rDs6!$7\e(B
 428     \e$B$F$$$?$@$-$^$7$?!%\e(B
 429
 430   o \e$B3F<oJ8;z%;%C%H!$%3!<%I7O$K$D$$$F!$F|K\8l\e(B PostgreSQL \e$B%a!<%j%s%0%j%9%H\e(B
 431     \e$B$N%a%s%P$NJ}$+$i%"%I%P%$%9$rD:$-$^$7$?!%$3$3$K46<U$7$^$9!%\e(B
 432     \e$B$^$?!$\e(BSJIS \e$BBP1~$K$D$$$F$O!$;T@n\e(B@\e$B$*CcBg$5$s$N%Q%C%A$r;29M$K$5$;$F$$\e(B
 433     \e$B$?$@$-$^$7$?!%\e(B
 434
 435   o SJIS\e$B%f!<%6Dj5AJ8;z\e(B (UDC) \e$B$r$I$&07$&$+$H8@$&$3$H$K$D$$$FCf>r$5$s\e(B
 436     (nak@email.com)\e$B$+$iLdBjDs5/$H>\:Y$J2r@b$rD:$-$^$7$?!%\e(B
 437
 438 \e$B"#\e(BUnicode\e$B$H$=$l0J30$N%(%s%3!<%G%#%s%0$H$NAj8_JQ49$K$D$$$F\e(B
 439
 440   PostgreSQL 7.1\e$B$+$i\e(BUnicode\e$B$H$=$l0J30$N%(%s%3!<%G%#%s%0$H$NAj8_JQ49$,\e(B
 441   \e$B2DG=$K$J$j$^$7$?!%$3$NJQ49$O$4$/0lIt$NJ8;z%3!<%I\e(B(ISO 8859-1)\e$B$r$N$>$-!$\e(B
 442   \e$B%m%8%C%/$K$h$kJQ49$,$G$-$J$$$?$a!$JQ49$N:]$K$O%F!<%V%k$,I,MW$K$J$j$^\e(B
 443   \e$B$9!%\e(BPostgreSQL\e$B$N<BAu$G$O!$\e(BUnicode\e$BJQ49%F!<%V%k$O\e(B Unicode organization
 444   \e$B$,Ds6!$9$k$b$N$r;HMQ!$$3$l$r\e(BPerl\e$B%W%m%0%i%`$G\e(BC\e$B8@8l$N%F!<%V%k$KJQ49$7\e(B
 445   \e$B$F:n@.$7$F$$$^$9\e(B(Perl\e$B%W%m%0%i%`$O\e(BNARITA Tomio\e$B;a:n@.$N\e(Blv\e$B%P!<%8%g%s\e(B
 446   4.3.6 \e$B$KIUB0$9$k$b$N$r2~B$$N>e!$MxMQ$7$F$$$^$9\e(B)\e$B!%\e(BUnicode
 447   organization\e$B$NDs6!$9$kJQ49%F!<%V%k$O:FG[I[$,5v2D$5$l$F$$$J$$$?$a!$\e(B
 448   PostgreSQL\e$B$N%=!<%9%3!<%I$K$O4^$^$l$F$$$^$;$s!%0J2<!$;HMQ$7$?JQ49%F!<\e(B
 449   \e$B%V%k$rNs5s$7$^$9!%\e(B
 450
 451   \e$B%(%s%3!<%G%#%s%0\e(B        \e$BJQ49%F!<%V%k\e(B
 452   ============================================================
 453   ISO 8859-1            \e$B$J$7\e(B
 454   ISO 8859-2            8859-2.TXT
 455   ISO 8859-3            8859-3.TXT
 456   ISO 8859-4            8859-4.TXT
 457   ISO 8859-5            8859-5.TXT
 458   ISO 8859-6            8859-6.TXT
 459   ISO 8859-7            8859-7.TXT
 460   ISO 8859-8            8859-8.TXT
 461   ISO 8859-9            8859-9.TXT
 462   ISO 8859-10           8859-10.TXT
 463   ISO 8859-13           8859-13.TXT
 464   ISO 8859-14           8859-14.TXT
 465   ISO 8859-15           8859-15.TXT
 466   ISO 8859-16           8859-16.TXT
 467   EUC_JP                JIS0201.TXT, JIS0208.TXT, JIS0212.TXT,
 468                         CP932.TXT, sjis.map
 469   SJIS                  CP932.TXT
 470   EUC_CN                GB2312.TXT
 471   GBK                   CP936.TXT
 472   EUC_KR                KSX1001.TXT
 473   UHC                   CP949.TXT
 474   JOHAB                 JOHAB.TXT
 475   EUC_TW                CNS11643.TXT
 476   Big5                  BIG5.TXT
 477   WIN1256               CP1256.TXT
 478   TCVN                  CP1258.TXT
 479   WIN874                CP874.TXT
 480   ============================================================
 481
 482 \e$B<U<-!'\e(B
 483
 484   o \e$BFA2H\e(B@\e$B;06(1?M"%5!<%S%9$5$s$+$i!$\e(BCP932.TXT\e$B$h$j@8@.$7$?\e(BSJIS\e$BMQ$NJQ49%F!<\e(B
 485     \e$B%V%k$rDs6!$7$F$$$?$@$-$^$7$?!%$3$l$K$h$j!$\e(BIBM \e$B3HD%J8;zNN0h\e(B (SJIS
 486     115\e$B!A\e(B120 \e$B6h\e(B), NEC \e$BA*Dj\e(B IBM \e$B3HD%J8;zNN0h\e(B (SJIS 89\e$B!A\e(B92 \e$B6h\e(B)\e$B$KBP1~$9$k\e(B
 487     \e$B$3$H$,$G$-$k$h$&$K$J$j$^$7$?!%\e(B
 488
 489
 490 \e$B;29M\e(B1\e$B!'\e(B
 491
 492   Pavel Behal\e$B;a$K$h$jDs6!$5$l$?\e(BWIN1250\e$B%5%]!<%H$G$9$,!$\e(BWindows\e$B4D6-$G$N\e(B
 493   \e$BMxMQ$N;EJ}$K$D$$$F;29M$K$J$k%I%-%e%a%s%H$,IUB0$7$F$$$k$N$G!$$3$3$KE:\e(B
 494   \e$BIU$7$F$*$-$^$9!%\e(B
 495
 496   -------------------------------------------------------------------
 497 Version: 0.91 for PgSQL 6.5
 498 Author: Pavel Behal
 499 Revised by: Tatsuo Ishii
 500 Email: behal@opf.slu.cz
 501 Licence: The Same as PostgreSQL
 502
 503 Sorry for my Eglish and C code, I'm not native :-)
 504
 505 !!!!!!!!!!!!!!!!!!!!!!!!! NO WARRANTY !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
 506
 507 Instalation:
 508 ------------
 509 1) Change three affected files in source directories
 510     (I don't have time to create proper patch diffs, I don't know how)
 511         [PostgreSQL 6.5.1\e$B$G$O$3$N%9%F%C%W$OI,MW$"$j$^$;$s!%\e(B-- \e$B@P0f\e(B]
 512 2) Compile with enabled locale and multibyte set to LATIN2
 513 3) Setup properly your instalation, do not forget to create locale
 514    variables in your profile (environment). Ex. (may not be exactly true):
 515         LC_ALL=cs_CZ.ISO8859-2
 516         LC_COLLATE=cs_CZ.ISO8859-2
 517         LC_CTYPE=cs_CZ.ISO8859-2
 518         LC_MONETARY=cs_CZ.ISO8859-2
 519         LC_NUMERIC=cs_CZ.ISO8859-2
 520         LC_TIME=cs_CZ.ISO8859-2
 521 4) You have to start the postmaster with locales set!
 522 5) Try it with Czech language, it have to sort
 523 5) Install ODBC driver for PgSQL into your M$ Windows
 524 6) Setup properly your data source. Include this line in your ODBC
 525    configuration dialog in field "Connect Settings:" :
 526         SET CLIENT_ENCODING = 'WIN1250';
 527 7) Now try it again, but in Windows with ODBC.
 528
 529 Description:
 530 ------------
 531 - Depends on proper system locales, tested with RH6.0 and Slackware 3.6,
 532   with cs_CZ.iso8859-2 loacle
 533 - Never try to set-up server multibyte database encoding to WIN1250,
 534   always use LATIN2 instead. There is not WIN1250 locale in Unix
 535 - WIN1250 encoding is useable only for M$W ODBC clients. The characters are
 536   on thy fly re-coded, to be displayed and stored back properly
 537
 538 Important:
 539 ----------
 540 - it reorders your sort order depending on your LC_... setting, so don't be
 541   confused with regression tests, they don't use locale
 542 - "ch" is corectly sorted only in some newer locales (Ex. RH6.0)
 543 - you have to insert money as '162,50' (with comma in aphostrophes!)
 544 - not tested properly
 545   -------------------------------------------------------------------
 546
 547 \e$B;29M\e(B2\e$B!'\e(BSJIS\e$B%f!<%6Dj5AJ8;z\e(B (UDC) \e$B$r$I$&07$&$+$H8@$&$3$H$K$D$$$FCf>r$5$s\e(B
 548     (nak@email.com)\e$B$+$i$$$?$@$$$?LdBjDs5/$H2r@b$G$9!%\e(B
 549
 550 -------------------------- \e$B0zMQ3+;O\e(B ----------------------------------
 551 ---
 552 1. SJIS \e$B%3!<%I$NHO0O\e(B
 553
 554     1 \e$B%P%$%HL\\e(B 0x81 - 0x9F\e$B!$\e(B0xE0 - 0xFC
 555     2 \e$B%P%$%HL\\e(B 0x40 - 0x7E\e$B!$\e(B0x80 - 0xFC
 556
 557     \e$B$$$o$f$k!V30;zNN0h!W$NHO0O\e(B:
 558
 559     - X0208 \e$B6&DL<+M3NN0h\e(B
 560
 561     |--------------------
 562     | 85 \e$B6h\e(B  0xEB40 \e$B!A\e(B
 563     |...
 564     |--------------------
 565     | 89 \e$B6h\e(B  0xED40 \e$B!A\e(B    ; 89\e$B!A\e(B92 \e$B6h$O\e(B
 566     |...                  ; \e$B!V\e(BNEC \e$BA*Dj\e(B IBM \e$B3HD%J8;zNN0h!W\e(B
 567     |-------------------- ; \e$B$H8F$P$l$k\e(B
 568     | 93 \e$B6h\e(B  0xEF40 \e$B!A\e(B
 569     | 94 \e$B6h\e(B  0xEF9F \e$B!A\e(B 0xEFFC
 570
 571     - \e$B%f!<%6Dj5AJ8;zNN0h\e(B
 572
 573     |--------------------
 574     | 95 \e$B6h\e(B  0xF040 \e$B!A\e(B    ; 95\e$B!A\e(B104 \e$B6h\e(B
 575     |...                  ; \e$B!V%f!<%6Dj5AJ8;zNN0h\e(B A\e$B!W\e(B(\e$B2>>N\e(B)
 576     |--------------------
 577     |105 \e$B6h\e(B  0xF540 \e$B!A\e(B    ; 105\e$B!A\e(B114 \e$B6h\e(B
 578     |...                  ; \e$B!V%f!<%6Dj5AJ8;zNN0h\e(B B\e$B!W\e(B(\e$B2>>N\e(B)
 579     |--------------------
 580     |115 \e$B6h\e(B  0xFA40 \e$B!A\e(B    ; 115\e$B!A\e(B120 \e$B6h$O0lHL$K\e(B
 581     |...                  ; \e$B!V\e(BIBM \e$B3HD%J8;zNN0h!W\e(B
 582     |120 \e$B6h\e(B  ...          ; \e$B$H8F$P$l$k\e(B
 583     |--------------------
 584
 585 ---
 586 2. i-mode \e$BC<Kv$,;H$C$F$$$k?^7AJ8;z%3!<%I$NHO0O\e(B
 587
 588     0xF89F - 0xF8FC  (112 \e$B6h\e(B)
 589     0xF940 - 0xF949  (113 \e$B6h\e(B)
 590     0xF972 - 0xF97E  (113 \e$B6h\e(B)
 591     0xF980 - 0xF990  (113 \e$B6h\e(B)
 592     0xF9B0           (114 \e$B6h\e(B)
 593
 594 ---
 595 3. \e$B0lHLE*$J\e(B EUC \e$BF|K\8l%3!<%I$NDj5A\e(B
 596
 597     G0 : [0x21-0x7E]                  ; \e$B$$$o$f$k\e(B JIS ROMAN
 598     G1 : [0xA1-0xFE] [0xA1-0xFE]      ; JIS X 0208
 599     G2 : 0x8E [0xA1-0xDF]             ; JIS X 0201 \e$B%+%J\e(B
 600     G3 : 0x8F [0xA1-0xFE] [0x21-0x7E] ; JIS X 0212 \e$BJd=u4A;z\e(B
 601
 602 ---
 603 [\e$BLdBjE@\e(B]
 604
 605 SJIS 95\e$B!A\e(B120 \e$B6h$O\e(B JIS X0208 \e$B$K3:Ev$9$kNN0h$,B8:_$7$J$$\e(B
 606 \e$B$?$a!$$3$NNN0h$N\e(B EUC - SJIS \e$BJ8;z%3!<%IJQ49$O3F%Y%s%@$K\e(B
 607 \e$B$h$C$F0[$J$k$N$G$O$J$$$+!$$H$$$&$N$,@P0fMM$+$i$N$4;XE&\e(B
 608 \e$B$G$7$?!%\e(B
 609
 610 ---
 611 [\e$B5DO@\e(B]
 612
 613 \e$BD4::$N7k2L!$\e(BSJIS 95\e$B!A\e(B120 \e$B6h$r\e(B EUC \e$B$KJQ49$9$k$?$a$NI8=`E*$J\e(B
 614 \e$B%k!<%k$,$J$$$o$1$G$O$J$$!$$H$$$&$3$H$,$o$+$j$^$7$?!%>\:Y$O\e(B
 615 \e$B8e=R$N;29M;qNA$r$4Mw$$$?$@$/$H$7$F!$$3$3$G$O$=$N%k!<%k$r\e(B
 616 \e$B4JC1$K$4@bL@$$$?$7$^$9!%\e(B
 617
 618    - SJIS \e$B%f!<%6Dj5AJ8;zNN0h\e(B A (\e$B2>>N\e(B)
 619           95\e$B!A\e(B104 \e$B6h\e(B  \e$B"+"*\e(B \e$BF|K\8l\e(B EUC / G1 85\e$B!A\e(B95 \e$B6h\e(B
 620
 621          \e$B$?$H$($P\e(B SJIS \e$B$N\e(B (95, 1) = 0xF040 \e$B$O\e(B
 622          EUC \e$B$N\e(B 0xF5A1 \e$B$K$J$j$^$9!%\e(B
 623
 624    - SJIS \e$B%f!<%6Dj5AJ8;zNN0h\e(B B (\e$B2>>N\e(B)
 625          105\e$B!A\e(B114 \e$B6h\e(B  \e$B"+"*\e(B \e$BF|K\8l\e(B EUC / G3 85\e$B!A\e(B95 \e$B6h\e(B
 626
 627          \e$B$?$H$($P\e(B SJIS \e$B$N\e(B (105, 1) = 0xF540 \e$B$O\e(B
 628          EUC \e$B$N\e(B 0x8FF5A1 \e$B$K$J$j$^$9!%\e(B
 629
 630    - IBM \e$B3HD%J8;zNN0h\e(B
 631          115\e$B!A\e(B120 \e$B6h\e(B
 632
 633          JIS X 0208 (\e$BF|K\8l\e(B EUC / G1)\e$B!$\e(BJIS X 0212
 634          (\e$BF|K\8l\e(B EUC / G3) \e$B$K3:Ev$9$kJ8;z$,$"$k>l9g\e(B
 635          \e$B$O$=$NJ8;z$K%^%C%T%s%0!%$=$&$G$J$$>l9g$O\e(B
 636          \e$BF|K\8l\e(B EUC / G3 83\e$B!A\e(B84 \e$B6h$r!$6hE@%3!<%I$N>e0L\e(B
 637          \e$B$+$i=g$K3d$jEv$F$F$$$/\e(B (\e$BJQ49%F!<%V%kJ}<0\e(B)
 638
 639 \e$B$3$N;EMM$O!$9-$/;H$o$l$F$$$k\e(B SJIS \e$B$H\e(B EUC \e$B$N%^%C%T%s%0$,%Y%s%@$K\e(B
 640 \e$B$h$C$F0[$J$k$?$a!$Aj8_1?MQ$N:]$KLdBj$K$J$C$F$$$k$3$H$+$i!$\e(B1996
 641 \e$BG/$K\e(B OSF \e$BF|K\%Y%s%@6(5D2q$,8!F$:n@.$7$?Js9p=q$,%Y!<%9$K$J$C$F$$\e(B
 642 \e$B$k$h$&$G$9!%\e(B
 643
 644 Solaris \e$B$N%I%-%e%a%s%H$K$O!V\e(BTOG \e$BF|K\%Y%s%@6(5D2q?d>)\e(B EUC\e$B!&%7%U%H\e(B
 645 JIS \e$B%3!<%IJQ49;EMM!W$K$b$H$E$/$H=q$$$F$"$j!$\e(BSolaris 2.6 \e$B$+$iF3F~\e(B
 646 \e$B$7$F$$$k$N$@$=$&$G!$;d$+$i8+$l$P;v<B>e$NI8=`$H9M$($F$bIT<+A3$G$O\e(B
 647 \e$B$J$$$H46$8$^$9!%\e(B
 648
 649 \e$B$J$*!$>/$J$/$H$b\e(B 1996 \e$BG/Ev;~$K$*$$$F$O!$\e(BOracle \e$B$d\e(B Sybase \e$B$O\e(B
 650 SJIS \e$B$N%f!<%6Dj5A\e(B/\e$B%Y%s%@Dj5AJ8;zNN0h$r\e(B EUC \e$B$KJQ49$9$k:]!$H=JLIT\e(B
 651 \e$B2DG=J8;z$H$7$F07$C$F$$$k$i$7$$$H$$$&$3$H$bJdB-$7$F$*$-$^$9!%\e(B
 652
 653 ---
 654 [\e$B;29M;qNA\e(B]
 655
 656 // URL \e$B$,D9$$$N$G!$ESCf$G@Z$l$J$$$H$$$$$N$G$9$,\e(B...
 657
 658 -\e$B!VF|K\8l\e(B EUC\e$B!&%7%U%H\e(B JIS \e$B%3!<%IJQ49;EMM$H%3!<%I7O<BBVD4::!W\e(B
 659     1966, OSF \e$BF|K\%Y%s%@6(5D2q\e(B
 660     http://www.opengroup.or.jp/jvc/cde/sjis-euc.html
 661
 662 -\e$B!VJ8;z%3!<%IJQ495,B'!W\e(B
 663     Solaris 7\e$B!$\e(BJFP \e$B%f!<%6!<%:%,%$%I\e(B
 664     http://docs.sun.com/ab2/coll.139.3/JFPUG/@Ab2PageView/11683?Ab2Lang=ja&Ab2Enc=euc-jp
 665
 666 -\e$B!VF|K\8lJ8;z%3!<%I!W\e(B
 667     Solaris 7\e$B!$\e(BJFP \e$B%f!<%6!<%:%,%$%I\e(B
 668     http://docs.sun.com/ab2/coll.139.3/JFPUG/@Ab2PageView/879;td=5?Ab2Lang=ja&Ab2Enc=euc-jp
 669
 670     // \e$BFf$N!V\e(B1\e$B!A\e(B20 \e$B6h!W$N5-=R$O$3$3$+$i$-$F$$$^$9!%\e(B
 671
 672 ---
 673 -------------------------- \e$B0zMQ$3$3$^$G\e(B ---------------------------------
 674
 675 \e$B2~DjMzNr!'\e(B
 676
 677   2002/10/21
 678         * \e$B%^%k%A%P%$%HBP1~$,%*%W%7%g%s$G$O$J$/!$8GDj$GI,$:AH$_9~$^$l$k\e(B
 679           \e$B$h$&$K$J$j$^$7$?!%\e(B
 680
 681         * CREATE CONVERSION/DROP CONVERSION\e$B$NDI2C!%$3$l$K$H$b$J$$!$%(\e(B
 682           \e$B%s%3!<%G%#%s%0JQ494X?t$,%m!<%@%V%k4X?t$K$J$j!$%P%C%/%(%s%I$N\e(B
 683           \e$B%m!<%I%b%8%e!<%k%5%$%:$,\e(B7.2\e$B$h$j$b>.$5$/$J$C$F$$$^$9!%$^$?!$\e(B
 684           SQL\e$BI8=`$N\e(BCONVERT\e$B4X?t$rDI2C$7$^$7$?!%\e(B
 685         * \e$B$$$/$D$+%(%s%3!<%G%#%s%0$,DI2C$5$l$F$$$^$9!%\e(B
 686         * \e$B0J>e!$\e(B7.3\e$B$KH?1G$5$l$^$9!%\e(B
 687
 688   2001/10/01
 689         * CONVERT\e$B$NDI2C!%\e(Blpad/rpad/trim/btrim/ltrim/rtrim/translate\e$B$N\e(B
 690           \e$B%^%k%A%P%$%HBP1~DI2C!%\e(Bchar/varchar\e$B$G%P%$%H?t$G$O$J$/!$J8;z?t\e(B
 691           \e$B$G%5%$%:$rDj5A$9$k$h$&$KJQ99!%0J>e!$\e(B7.2\e$B$KH?1G$5$l$^$9!%\e(B
 692
 693   2001/2/15
 694         * \e$BFA2H\e(B@\e$B;06(1?M"%5!<%S%9$5$s$+$i!$\e(BCP932.TXT\e$B$h$j@8@.$7$?\e(BSJIS\e$BMQ$N\e(B
 695           \e$BJQ49%F!<%V%k$rDs6!$7$F$$$?$@$-$^$7$?!%\e(B7.1\e$B$KH?1G$5$l$^$9!%\e(B
 696
 697   2001/1/6
 698         * UNICODE\e$B$HB>$N%(%s%3!<%G%#%s%0$H$NAj8_JQ495!G=$rDI2C!%\e(B
 699         * 7.1\e$B$KH?1G$5$l$^$9!%\e(B
 700
 701   2000/5/20
 702         * NEC \e$BA*Dj\e(B IBM \e$B4A;zBP1~$rDI2C$7$^$7$?!%$3$l$O\e(B \e$BFA2H\e(B@\e$B;06(1?M"%5!<%S%9\e(B
 703           \e$B$5$s$+$i$N\e(B contribute \e$B$G$9!%\e(B
 704         * \e$B$3$l$i$O!$\e(B7.0.1 \e$B$KH?1G$5$l$^$9!%\e(B
 705
 706   2000/3/22
 707         * PQsetClientEncoding, PQclientEncoding \e$B$r\e(Blibpq \e$B4X?t$KDI2C!$\e(B
 708           \e$B%3%M%/%7%g%sKh$K%(%s%3!<%G%#%s%0$rJQ992DG=$K!%\e(B
 709         * SJIS \e$B%f!<%6Dj5AJ8;z\e(B (UDC) \e$B$X$NBP1~\e(B
 710         * ./configure --with-mb=EUC_JP \e$B$+$i\e(B
 711           ./configure --enable-multibyte=EUC_JP \e$B$KJQ99\e(B
 712         * SQL_ASCII \e$B$N\e(B regression test \e$BDI2C\e(B
 713         * \e$B$3$l$i$O\e(B 7.0 \e$B$KH?1G$5$l$^$9!%\e(B
 714
 715   1999/7/11 WIN1250(Windows\e$BMQ$N%A%'%38l\e(B)\e$B%5%]!<%H$rDI2C$7$^$7$?!%\e(B
 716         * WIN1250 \e$B$,%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0$H$7$FMxMQ$G$-$k$h\e(B
 717           \e$B$&$K$J$j$^$7$?!%$3$N>l9g!$%P%C%/%(%s%IB&$N%(%s%3!<%G%#%s%0$O\e(B
 718           LATIN2 \e$B$^$?$O\e(B MULE_INTERNAL \e$B$H$7$^$9!%\e(B
 719           (contributed by Pavel Behal)
 720         * backend/utils/mb/conv.c\e$B$K$*$1$k7?$NIT@09g$r=$@5$7$^$7$?!%\e(B
 721           (contributed by Tomoaki Nishiyama)
 722         * \e$B$3$l$i$O\e(B6.5.1\e$B$KH?1G$5$l$^$9!%\e(B
 723
 724   1999/3/23 \e$B%-%j%kJ8;z%5%]!<%HDI2CB>\e(B(6.5 \e$B$KH?1G:Q\e(B)
 725         * \e$B%(%s%3!<%G%#%s%0$H$7$F\e(B KOI8(KOI8-R), WIN(CP1251), ALT(CP866) \e$B$r\e(B
 726           \e$B%5%]!<%H$7$F$$$^$9!%$3$l$i$O!$%U%m%s%H%(%s%I!$%P%C%/%(%s%I!$\e(B
 727           \e$B$I$A$i$N%(%s%3!<%G%#%s%0$H$7$F$b;HMQ2DG=$G$"$j!$%(%s%3!<%G%#%s%0$N\e(B
 728           \e$BAj8_JQ49$,2DG=$G$9!%$^$?!$=>Mh$+$i%5%]!<%H$7$F$$$k\e(B ISO 8859-5 \e$B$b\e(B
 729           \e$BF1MM$K;HMQ2DG=$G$9!%\e(B
 730           \e$B%-%j%kJ8;z%5%]!<%H$O!$\e(BOleg Broytmann <phd@sun.med.ru> \e$B;a$N\e(B
 731           \e$B%j%/%(%9%H5Z$S6(NO$K$h$j<B8=$7$^$7$?!%$3$l$O!$=>Mh$+$i$"$k\e(B
 732           RCODE \e$B%5%]!<%H$N5!G=$r<h$j9~$`$b$N$G$b$"$j$^$9!%\e(B
 733         * MB \e$B$H\e(B locale \e$B$rF1;~$K;XDj$7$?>l9g$KBgJ8;z!?>.J8;z$rL5;k$7$?\e(B
 734           \e$B@55,I=8=8!:w$,@5>o$KF0:n$7$J$$%P%0$r=$@5\e(B
 735
 736   1999/1/26 Big5 \e$B%5%]!<%HDI2C\e(B(6.4.2-patched/6.5 \e$B$KH?1G:Q\e(B)
 737         * Big5 \e$B$,%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0$H$7$FMxMQ$G$-$k$h\e(B
 738           \e$B$&$K$J$j$^$7$?!%$3$N>l9g!$%P%C%/%(%s%IB&$N%(%s%3!<%G%#%s%0$O\e(B
 739           EUC_TW \e$B$^$?$O\e(B MULE_INTERNAL \e$B$H$7$^$9!%\e(B
 740         * EUC_TW \e$B$N\e(B regression test \e$B%1!<%9$rDI2C\e(B
 741           (contributed by Jonah Kuo <jonahkuo@mail.ttn.com.tw>)
 742
 743   1998/12/16 \e$BK\%I%-%e%a%s%H=$@5\e(B(6.4.2 \e$B$KH?1G:Q\e(B)\e$B!%\e(B
 744         * Makefile.custom \e$B$G\e(B MB=EUC_JP \e$B$J$I$H@_Dj$9$kJ}K!$O\e(B 6.4 \e$B0J9_\e(B
 745           \e$B%5%]!<%H$5$l$F$$$J$$$N$G:o=|$7$?!%\e(B
 746         * \e$BJ8;z%3!<%I\e(B \e$B"*\e(B \e$B%(%s%3!<%G%#%s%0!$%/%i%$%"%s%H"*%U%m%s%H%(%s%I\e(B
 747           \e$B%5!<%P"*%P%C%/%(%s%I\e(B \e$B$K$=$l$>$l8l6g$r=$@5!%\e(B
 748
 749   1998/12/15 6.4 \e$B8~$1%P%0=$@5%Q%C%A%j%j!<%9\e(B(6.4.2 \e$B$KH?1G:Q\e(B)\e$B!%\e(B
 750         * SQL_ASCII \e$B%5%]!<%H$N%P%0=$@5\e(B
 751
 752   1998/11/21 6.4 \e$B8~$1%P%0=$@5%Q%C%A%j%j!<%9\e(B(6.4.2 \e$B$KH?1G:Q\e(B)\e$B!%\e(B
 753         * BINARY CURSOR \e$B$NLdBj$r=$@5\e(B
 754         * pg_dumpall \e$B$N%P%0=$@5\e(B
 755
 756   1998/11/5 6.4 \e$B%j%j!<%9!%\e(B
 757         * pg_database \e$B$N\e(B encoding \e$B%+%i%`$,\e(B MB \e$B$,M-8z$G$J$$$H$-$K$b\e(B
 758           \e$BDI2C$5$l$k$h$&$K$J$C$?!%$=$N$?$a!$\e(BMB \e$B$,M-8z$G$J$$$H$-$K$O!$\e(B
 759           ASCII \e$B$N%(%s%3!<%G%#%s%0$rI=$9\e(B SQL_ASCII \e$B$r?7$7$$%(%s%3!<%G%#%s%0\e(B
 760           \e$B$H$7$FDI2C$7$?!%$3$l$K$H$b$J$$!$%(%s%3!<%G%#%s%0L>$KBP1~$9$k\e(B
 761           \e$B%(%s%3!<%G%#%s%0\e(BID\e$B$,\e(B SQL_ASCII \e$B$r\e(B 0 \e$B$H$9$kHV9f$KJQ99$K$J$C$?!%\e(B
 762
 763   1998/7/22 6.4 \e$B&A8~$1$K%Q%C%A$r%j%j!<%9!%\e(B
 764         * initdb/createdb/create database \e$B$G%P%C%/%(%s%IB&$N\e(B
 765           \e$B%(%s%3!<%G%#%s%0$r@_Dj$-$k5!G=<BAu!%$3$N$?$a!$%7%9%F%`%+%?%m\e(B
 766           \e$B%0$N\e(B pg_database \e$B$K?7$7$$%+%i%`\e(B encoding \e$B$rDI2C\e(B(MB\e$B$,M-8z$J;~$@$1\e(B)
 767         * copy \e$B$,\e(B PGCLIENTENCODING \e$B$KBP1~\e(B
 768         * SQL92 \e$B$N\e(B "SET NAMES" \e$B$r%5%]!<%H\e(B(MB\e$B$,M-8z$J;~$@$1\e(B)
 769         * LATIN2-5 \e$B$r%5%]!<%H\e(B
 770         * regression test \e$B$K\e(B unicode \e$B$N%F%9%H%1!<%9$rDI2C\e(B
 771         * MB \e$B@lMQ$N\e(B regression \e$B%F%9%H%G%#%l%/%H%j\e(B test/mb \e$B$rDI2C\e(B
 772         * \e$B%=!<%9%U%!%$%k$NCV$->l=j$rBgI}8+D>$7!%\e(BMB \e$B4X78$O\e(B
 773           include/mb, backend/utils/mb \e$B$KCV$/$h$&$K$7$?\e(B
 774
 775   1998/5/25 \e$B%P%0=$@5\e(B(mb_b3.patch \e$B$H$7$F\e(B pgsql-jp ML \e$B$K%j%j!<%9!$\e(B
 776         \e$BK\2H$G$O\e(B 6.4 snapshot \e$B$K<h$j9~$^$l$kM=Dj\e(B)
 777
 778   1998/5/18 \e$B5!G=DI2C!?%P%0=$@5\e(B(mb_b2.patch \e$B$H$7$F\e(B pgsql-jp ML \e$B$K%j%j!<%9!$\e(B
 779         \e$BK\2H$G$O\e(B 6.4 snapshot \e$B$K<h$j9~$^$l$kM=Dj\e(B)
 780         * \e$B4D6-JQ?t\e(B PGCLIENTENCODING \e$B$N%5%]!<%H!%%U%m%s%H%(%s%IB&$N\e(B
 781           \e$B%(%s%3!<%G%#%s%0$r;XDj$9$k!%8=:_!$\e(BSJIS, EUC_*, MULE_INTERNAL,
 782           LATIN1 \e$B$,;XDj$G$-$k!%$^$?!$\e(B
 783           set client_encoding to 'sjis';
 784           \e$B$G$b2DG=\e(B
 785         * 8bit \e$BJ8;z$,EO$k$HLdBj$,5/$-$k2U=j$K$G$-$k$@$1BP1~\e(B
 786
 787   1998/4/21 \e$B5!G=DI2C!?%P%0=$@5\e(B(mb_b1.patch \e$B$H$7$F\e(B pgsql-jp ML \e$B$K%j%j!<%9!$\e(B
 788         \e$BK\2H$G$O\e(B 6.4 snapshot \e$B$K<h$j9~$^$l$F$$$k\e(B)
 789         * character_length(), position(), substring() \e$B$N%^%k%A%P%$%H\e(B
 790           \e$BBP1~\e(B
 791         * octet_length() \e$BDI2C\e(B \e$B"*\e(B initdb \e$B$N$d$jD>$7I,MW\e(B
 792         * configure \e$B$N%*%W%7%g%s$K\e(B MB \e$B%5%]!<%HDI2C\e(B
 793           (ex. configure --with-mb=EUC_JP)
 794         * EUC_KR \e$B$N\e(B regression test \e$BDI2C\e(B
 795           ("Soonmyung. Hong" <hong@lunaris.hanmesoft.co.kr> \e$B$5$sDs6!\e(B)
 796         * EUC_JP \e$B$N\e(B regression test \e$B$K\e(B character_length(), position(),
 797           substring(), octet_length() \e$BDI2C\e(B
 798         * regress.sh \e$B$N\e(B SystemV \e$B$K$*$1$kHs8_49@-=$@5\e(B
 799         * toupper(), tolower() \e$B$K\e(B 8bit \e$BJ8;z$,EO$k$HMn$A$k$3$H$,\e(B
 800           \e$B$"$k$N$r=$@5\e(B
 801
 802   1998/3/25 PostgreSQL 6.3.1 \e$B%j%j!<%9!$\e(BMB PL2 \e$B$,<h$j9~$^$l$k\e(B
 803
 804   1998/3/10 PL2 \e$B$r%j%j!<%9\e(B
 805         * EUC_JP, EUC_CN, MULE_INTERNAL \e$B$N\e(B regression test \e$B$rDI2C\e(B
 806           (EUC_CN \e$B$N%G!<%?$O\e(B he@sra.co.jp \e$B$5$sDs6!\e(B)
 807         * regexp \e$B$K$*$$$F!$\e(Bisalpha \e$B$J$I$K\e(B unsigend char \e$B0J30$NCM$,\e(B
 808           \e$BEO$i$J$$$h$&$K%,!<%I$r$+$1$k\e(B
 809         * \e$B1Q8l$N%I%-%e%a%s%H$rDI2C\e(B
 810         * MB \e$B$rDj5A$7$J$$>l9g$KH/@8$9$k%P%0$r=$@5\e(B
 811
 812   1998/3/1 PL1 \e$B$r%j%j!<%9\e(B
 813
 814 \e$B0J>e!%\e(B