Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitdb9b12b

Browse files
committed
Included are patches for doc/README.mb and README.mb.jp.
Please apply to both trees.--Tatsuo Ishii
1 parent47af45c commitdb9b12b

File tree

3 files changed

+163
-73
lines changed

3 files changed

+163
-73
lines changed

‎doc/README.mb

Lines changed: 37 additions & 12 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
postgresql 6.4 multi-byte (MB) support READMEJul 22 1998
1+
postgresql 6.4 multi-byte (MB) support READMEDec 16 1998
22

33
Tatsuo Ishii
44
t-ishii@sra.co.jp
@@ -11,7 +11,7 @@ multi-byte character sets such as EUC(Extended Unix Code), Unicode and
1111
Mule internal code. With the MB enabled you can use multi-byte
1212
character sets in regexp ,LIKE and some functions. The encoding system
1313
chosen is determined when initializing your PostgreSQL installation
14-
using initdb(1). Note that this can beoverrided when creating a
14+
using initdb(1). Note that this can beoverridden when creating a
1515
database using createdb(1) or create database SQL command. So you
1616
could have multiple databases with different encoding system.
1717

@@ -23,16 +23,13 @@ me know if you find any problem while using 8-bit characters)
2323

2424
1. How to use
2525

26-
create src/Makefile.custom with a line including:
27-
28-
MB=encoding_system
29-
30-
or run configure with the mb option:
26+
run configure with the mb option:
3127

3228
% configure --with-mb=encoding_system
3329

3430
where encoding_system is one of:
3531

32+
SQL_ASCIIASCII
3633
EUC_JPJapanese EUC
3734
EUC_CNChinese EUC
3835
EUC_KRKorean EUC
@@ -47,11 +44,6 @@ where encoding_system is one of:
4744

4845
Example:
4946

50-
% cat Makefile.custom
51-
MB=EUC_JP
52-
53-
or
54-
5547
% configure --with-mb=EUC_JP
5648

5749
If MB is disabled, nothing is changed except better supporting for
@@ -78,6 +70,31 @@ another way to accomplish this is to use a SQL command:
7870

7971
CREATE DATABASE korean WITH ENCODING = 'EUC_KR';
8072

73+
The encoding for a database is represented as "encoding" column in the
74+
pg_database system catalog.
75+
76+
datname |datdba|encoding|datpath
77+
-------------+------+--------+-------------
78+
template1 | 1739| 1|template1
79+
postgres | 1739| 0|postgres
80+
euc_jp | 1739| 1|euc_jp
81+
euc_kr | 1739| 3|euc_kr
82+
euc_cn | 1739| 2|euc_cn
83+
unicode | 1739| 5|unicode
84+
mule_internal| 1739| 6|mule_internal
85+
86+
A number in the encoding column is "encoding id" and can be translated
87+
to the encoding name using pg_encoding command.
88+
89+
$ pg_encoding 1
90+
EUC_JP
91+
92+
If an argument to pg_encoding is not a number, then it is regarded as
93+
an encoding name and pg_encoding will return the encoding id.
94+
95+
$ pg_encoding EUC_JP
96+
1
97+
8198
3. PGCLIENTENCODING
8299

83100
If an environment variable PGCLIENTENCODING is defined on the
@@ -90,6 +107,7 @@ backend would be translated to SJIS of course.
90107

91108
Supported encodings for PGCLIENTENCODING are:
92109

110+
SQL_ASCIIASCII
93111
EUC_JPJapanese EUC
94112
SJISYet another Japanese encoding
95113
EUC_CNChinese EUC
@@ -151,6 +169,13 @@ Unicode: http://www.unicode.org/
151169

152170
5. History
153171

172+
Dec 15, 1998
173+
* Bugs related to SQL_ASCII support fixed
174+
175+
Nov 5, 1998
176+
* 6.4 release. In this version, pg_database has "encoding"
177+
column that represents the database encoding
178+
154179
Jul 22, 1998
155180
* determine encoding at initdb/createdb rather than compile time
156181
* support for PGCLIENTENCODING when issuing COPY command

‎doc/README.mb.jp

Lines changed: 105 additions & 61 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
postgresql 6.4 multi-byte (MB) support README 1998/7/22 $B:n@.(B
1+
postgresql 6.4 multi-byte (MB) support README 1998/12/16 $B:n@.(B
22

33
$B@P0fC#IW(B
44
t-ishii@sra.co.jp
@@ -19,28 +19,25 @@ postgresql 6.4 multi-byte (MB) support README 1998/7/22 $B:n@.(B
1919
6.$B%^%k%A%P%$%HJ8;z$N(B LIKE $B8!:w$,;HMQ2DG=(B
2020
7.character_length(), position(), substring() $B$G$N%^%k%A%P%$%H(B
2121
$B%5%]!<%H(B
22-
8.$B4D6-JQ?t(B PGCLIENTENCODING $B$K$h$j!"%/%i%$%"%s%HB&$NJ8;z%3!<%I(B
22+
8.$B4D6-JQ?t(B PGCLIENTENCODING $B$K$h$j!"%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0(B
2323
$B$,%P%C%/%(%s%IB&$H0[$k>l9g$K!"<+F0E*$K%3!<%IJQ49$r9T$J$$$^$9!#(B
2424

2525
$B%$%s%9%H!<%k!'(B
2626

2727
$B%G%U%)%k%H$G$O(B PostgreSQL $B$O%^%k%A%P%$%H$r%5%]!<%H$7$F$$$^$;$s!#(B
2828
$B%^%k%A%P%$%H%5%]!<%H$rM-8z$K$9$kJ}K!$r@bL@$7$^$9!#(B
2929

30-
src/Makefile.custom $B$H$$$&%U%!%$%k$r:n$j!"(B
31-
32-
MB=EUC_JP
33-
34-
$B$N(B 1 $B9T$rDI2C$7$^$9!#$"$k$$$O!"(Bconfigure $B5/F0;~$K0J2<$N$h$&$K;XDj$7$^$9!#(B
30+
configure $B5/F0;~$K0J2<$N$h$&$K;XDj$7$^$9!#(B
3531

3632
% configure --with-mb=EUC_JP
3733

38-
$BJ8;z%3!<%I$H$7$F$O(B EUC_JP $B$r4^$a!"0J2<$N%3!<%I$,(B initdb $B$K$h$k(B
34+
$B%(%s%3!<%G%#%s%0$H$7$F$O(B EUC_JP $B$r4^$a!"0J2<$N%3!<%I$,(B initdb $B$K$h$k(B
3935
$B%G!<%?%Y!<%9=i4|2=;~$*$h$S%G!<%?%Y!<%9:n@.;~(B
4036
(Unix $B%3%^%s%I$N(B createdb $B$b$7$/$O(B SQL $B$N(B create database)
41-
$B$K;XDj$G$-$^$9!#(BMakefile.custom $B$"$k$$$O(Bconfigure $B$G;XDj$7$?J8;z%3!<(B
42-
$B%I$O(B initdb $B$N>JN,;~$NJ8;z%3!<%I$K$J$j$^$9!#(B
37+
$B$K;XDj$G$-$^$9!#(Bconfigure $B$G;XDj$7$?%(%s%3!<%G%#%s%0$O(Binitdb $B$N>JN,;~$N(B
38+
$B%(%s%3!<%G%#%s%0$K$J$j$^$9!#(B
4339

40+
SQL_ASCIIASCII
4441
EUC_JP$BF|K\8l(B EUC
4542
EUC_CNGB $B$r%Y!<%9$K$7$?CfJ8(BEUC$B!#(Bcode set 2 $B$O(B
4643
SS2+2$B%P%$%H%3!<%I(B = 3$B%P%$%HI=8=$G$9!#(B
@@ -72,105 +69,132 @@ postgresql 6.4 multi-byte (MB) support README 1998/7/22 $B:n@.(B
7269
http://www.sra.co.jp/people/t-ishii/PostgreSQL/ $B$G$b4JC1$J%$%s%9%H!<(B
7370
$B%kJ}K!$r>R2p$7$F$$$^$9!#(B
7471

75-
initdb/createdb/create database $B$K$*$1$kJ8;z%3!<%I$N;XDj$K$D$$$F(B
72+
initdb/createdb/create database $B$K$*$1$k%(%s%3!<%G%#%s%0$N;XDj$K$D$$$F(B
7673

77-
initdb $B$G$O0J2<$N%*%W%7%g%s$GJ8;z%3!<%I$,;XDj$G$-$^$9!#(B
74+
initdb $B$G$O0J2<$N%*%W%7%g%s$G%(%s%3!<%G%#%s%0$,;XDj$G$-$^$9!#(B
7875

79-
-e $BJ8;z%3!<%I(B
80-
-pgencoding $BJ8;z%3!<%I(B
76+
-e $B%(%s%3!<%G%#%s%0(B
77+
-pgencoding $B%(%s%3!<%G%#%s%0(B
8178

82-
$B$3$3$G;XDj$7$?J8;z%3!<%I$O!"0J8e(B createdb/create database $B$GJ8;z%3!<%I$r(B
83-
$B>JN,$7$?>l9g$K@_Dj$5$l$kJ8;z%3!<%I$K$J$j$^$9!#(B-e $B$^$?$O(B -pgencoding
84-
$B%*%W%7%g%s$r>JN,$7$?>l9g$O!"(BMakefile.custom $B$"$k$$$O(B configure $B$G;X(B
85-
$BDj$7$?J8;z%3!<%I$,:NMQ$5$l$^$9!#(B
79+
$B$3$3$G;XDj$7$?%(%s%3!<%G%#%s%0$O!"0J8e(B createdb/create database $B$G%((B
80+
$B%s%3!<%G%#%s%0$r>JN,$7$?>l9g$K@_Dj$5$l$k%(%s%3!<%G%#%s%0$K$J$j$^$9!#(B
81+
-e$B$^$?$O(B -pgencoding $B%*%W%7%g%s$r>JN,$7$?>l9g$O!"(Bconfigure $B$G;XDj$7(B
82+
$B$?%(%s%3!<%G%#%s%0$,:NMQ$5$l$^$9!#(B
8683

87-
createdb $B$G$O0J2<$N%*%W%7%g%s$GJ8;z%3!<%I$,;XDj$G$-$^$9!#(B
84+
createdb $B$G$O0J2<$N%*%W%7%g%s$G%(%s%3!<%G%#%s%0$,;XDj$G$-$^$9!#(B
8885

89-
-E $BJ8;z%3!<%I(B
86+
-E $B%(%s%3!<%G%#%s%0(B
9087

91-
create database $B$G$O0J2<$N%*%W%7%g%s$GJ8;z%3!<%I$,;XDj$G$-$^$9!#(B
88+
create database $B$G$O0J2<$N%*%W%7%g%s$G%(%s%3!<%G%#%s%0$,;XDj$G$-$^$9!#(B
9289

93-
CREATE DATABASE dbanme WITH ENCODING = '$BJ8;z%3!<%I(B';
90+
CREATE DATABASE dbanme WITH ENCODING = '$B%(%s%3!<%G%#%s%0(B';
9491

9592
LOCATION $B$rF1;~$K;XDj$9$k>l9g$O0J2<$N$h$&$K$J$j$^$9!#(B
9693

97-
CREATE DATABASE dbanme WITH LOCATION = 'path' ENCODING = '$BJ8;z%3!<%I(B';
94+
CREATE DATABASE dbanme WITH LOCATION = 'path' ENCODING = '$B%(%s%3!<%G%#%s%0(B';
95+
96+
createdb/create database $B$O!"%(%s%3!<%G%#%s%0;XDj$r>JN,$7$?>l9g$O!"(Binitdb
97+
$B$G;XDj$7$?%(%s%3!<%G%#%s%0$,:NMQ$5$l$^$9!#(B
98+
99+
$B%G!<%?%Y!<%9$N%(%s%3!<%G%#%s%0$O!"(Bpsql $B$N(B \l $B$d!"(BSQL $BJ8$N(B
100+
select * from pg_database $B$G;2>H$G$-$^$9!#(B
101+
102+
datname |datdba|encoding|datpath
103+
-------------+------+--------+-------------
104+
template1 | 1739| 1|template1
105+
postgres | 1739| 0|postgres
106+
euc_jp | 1739| 1|euc_jp
107+
euc_kr | 1739| 3|euc_kr
108+
euc_cn | 1739| 2|euc_cn
109+
unicode | 1739| 5|unicode
110+
mule_internal| 1739| 6|mule_internal
111+
112+
encoding $B%+%i%`$N?tCM$,$=$N%G!<%?%Y!<%9$N%(%s%3!<%G%#%s%0$rI=$7$^$9(B
113+
($B%(%s%3!<%G%#%s%0(BID)$B!#%(%s%3!<%G%#%s%0(B ID $B$r%(%s%3!<%G%#%s%0L>$KJQ49(B
114+
$B$9$k$K$O!"(Bpg_encoding $B%3%^%s%I$r;HMQ$7$^$9!#$?$H$($P!"(B
115+
116+
$ pg_encoding 1
117+
EUC_JP
98118

99-
createdb/create database $B$O!"J8;z%3!<%I;XDj$r>JN,$7$?>l9g$O!"(Binitdb
100-
$B$G;XDj$7$?J8;z%3!<%I$,:NMQ$5$l$^$9!#(B
119+
$B$N$h$&$K$J$j$^$9!#$J$*!"(Bpg_encoding $B$O?t;z0J30$,M?$($i$l$k$H%(%s%3!<(B
120+
$B%G%#%s%0L>$H8+Jo$7$F%(%s%3!<%G%#%s%0(BID$B$rJV$7$^$9!#(B
121+
122+
$ pg_encoding EUC_JP
123+
1
101124

102125
$B4D6-JQ?t(B PGCLIENTENCODING $B$K$D$$$F!'(B
103126

104127
$B4D6-JQ?t(B PGCLIENTENCODING $B$,@_Dj$5$l$F$$$J$$>l9g!"(Blibpq $B$O%;%C%7%g%s(B
105-
$B3+;O;~$K%5!<%PB&$KJ8;z%3!<%I$rLd$$9g$o$;!"$=$NCM$r4D6-JQ?t(B
128+
$B3+;O;~$K%P%C%/%(%s%IB&$K%(%s%3!<%G%#%s%0$rLd$$9g$o$;!"$=$NCM$r4D6-JQ?t(B
106129
PGCLIENTENCODING $B$K@_Dj$7$^$9!#(B
107130

108-
$B4D6-JQ?t(B PGCLIENTENCODING $B$,@_Dj$5$l$F$$$k>l9g$O$=$NCM$,M%@h$5$l!"%5!<(B
109-
$B%PB&$H0[$J$kJ8;z%3!<%I$,;HMQ$G$-$^$9!#@_Dj2DG=$JJ8;z%3!<%I$O!">e5-$K(B
110-
$B2C$(!"(BSJIS ($B%7%U%H(BJIS)$B$,;XDj$G$-$^$9!#(B
131+
$B4D6-JQ?t(B PGCLIENTENCODING $B$,@_Dj$5$l$F$$$k>l9g$O$=$NCM$,M%@h$5$l!"%P%C(B
132+
$B%/%(%s%IB&$H0[$J$k%(%s%3!<%G%#%s%0$,;HMQ$G$-$^$9!#@_Dj2DG=$J%(%s%3!<(B
133+
$B%G%#%s%0$O!">e5-$K2C$(!"(BSJIS ($B%7%U%H(BJIS)$B$,;XDj$G$-$^$9!#(B
111134

112135
$B$A$J$_$K!"(BSJIS $B$O(B JISX0201 $B$N(B 1$B%P%$%H%+%J!"$$$o$f$k!VH>3Q%+%?(B
113136
$B%+%J!W$b%5%]!<%H$7$F$$$^$9(B($B7h$7$F!VH>3Q%+%?%+%J!W$N;HMQ$r$*4+(B
114137
$B$a$7$F$$$k$o$1$8$c$J$$$G$9$,(B)$B!#(B
115138

116139
$B$?$H$($P!"(BMB=EUC_JP $B$G(B PostgeSQL $B$,%$%s%9%H!<%k$5$l$F$$$k>l9g!"(B
117140
postmaster $B$rN)$A>e$2$k$H$-$K4D6-JQ?t(B PGCLIENTENCODING $B$K(B SJIS $B$r@_(B
118-
$BDj$9$k$H!"%/%i%$%"%s%H$O(B SJIS $B%3!<%I$G(B PostgreSQL $B$K%"%/%;%9$G$-$k$h(B
141+
$BDj$9$k$H!"%U%m%s%H%(%s%I$O(B SJIS $B%3!<%I$G(B PostgreSQL $B$K%"%/%;%9$G$-$k$h(B
119142
$B$&$K$J$j$^$9!#$?$@$7!"%G!<%?%Y!<%9$K3JG<$5$l$k%G!<%?<+BN$O$"$/$^$G(B
120143
MB $B$G;XDj$7$?(B EUC_JP $B$N$^$^$G$9!#(B
121144

122-
$B%/%i%$%"%s%HB&$G%;%C%7%g%sKh$KJ8;z%3!<%I$rJQ$($k$3$H$b$G$-$^$9!#(B
123-
$B%;%C%7%g%s3+;O;~$K4D6-JQ?t(B PGCLIENTENCODING $B$,%;%C%H$5$l$F$$$k$H!"$=(B
124-
$B$l$,M%@h$5$l$F%/%i%$%"%s%HB&$NJ8;z%3!<%I$K:NMQ$5$l$^$9!#$3$N5!G=$rMx(B
145+
$B%U%m%s%H%(%s%IB&$G%;%C%7%g%sKh$K%(%s%3!<%G%#%s%0$rJQ$($k$3$H$b$G$-$^(B
146+
$B$9!#%;%C%7%g%s3+;O;~$K4D6-JQ?t(B PGCLIENTENCODING $B$,%;%C%H$5$l$F$$$k$H!"(B
147+
$B$=$l$,%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0$K:NMQ$5$l$^$9!#$3$N5!G=$rMx(B
125148
$BMQ$9$k$H!"$"$k%f!<%6$O(B EUC_JP $B$G!"JL$J%f!<%6$O(B SJIS $B$GF1$8%G!<%?%Y!<(B
126149
$B%9$K%"%/%;%9$9$k$H$$$&$h$&$J$3$H$,$G$-$k$h$&$K$J$j$^$9!#(B
127150

128151
MB=MULE_INTERNAL $B$G(B PostgreSQL $B$r%$%s%9%H!<%k$7$F$*$/$H!"IaCJ$O(B
129-
EUC_JP $B$G%/%i%$%"%s%H$rMxMQ$7!"J#?t$NJ8;z=89g$r:.:_$5$;$k$H$-$@$1%/(B
152+
EUC_JP $B$G%U%m%s%H%(%s%I$rMxMQ$7!"J#?t$NJ8;z=89g$r:.:_$5$;$k$H$-$@$1%/(B
130153
$B%i%$%"%s%H$r(B MULE_INTERNAL $B$K@_Dj$9$k$J$I$N;H$$J,$1$,$G$-$FJXMx$G$9!#(B
131154
$B$?$@!"0lHL$K(B EUC_JP $B$KHf$Y!"(BMULE_INTERNAL $B$K$h$k%G!<%?I=8=$O$d$d%9%Z!<(B
132155
$B%9$r6t$&$N$G!"$=$N$X$s$O9MN8$7$F$*$/I,MW$,$"$j$^$9!#$?$H$($P!"(B2$B%P%$(B
133156
$B%H$GI=8=$G$-$k4A;z$O(B MULE_INTERNAL $B$G$O(B 3$B%P%$%H$rMW$7$^$9!#(B
134157

135-
$BCm0U$7$F$*$/I,MW$,$"$k$N$O!"%5!<%PB&$NJ8;z%3!<%I$H%/%i%$%"%s%HB&$NJ8(B
136-
$B;z%3!<%I$,$$$D$bAj8_JQ49$G$-$k$H$O8B$i$J$$$3$H$G$9!#6KC<$JOC!"%5!<%P(B
137-
$BB&$,(B EUC_JP $B$J$N$K!"%/%i%$%"%s%HB&$,(B EUC_KR $B$@$C$?$i$I$&$J$k$G$7$g$&!#(B
158+
$BCm0U$7$F$*$/I,MW$,$"$k$N$O!"%P%C%/%(%s%IB&$N%(%s%3!<%G%#%s%0$H%U%m%s(B
159+
$B%H%(%s%IB&$N%(%s%3!<%G%#%s%0$,$$$D$bAj8_JQ49$G$-$k$H$O8B$i$J$$$3$H$G(B
160+
$B$9!#6KC<$JOC!"%P%C%/%(%s%IB&$,(B EUC_JP $B$J$N$K!"%U%m%s%H%(%s%IB&$,(B
161+
EUC_KR $B$@$C$?$i$I$&$J$k$G$7$g$&!#(B
138162
$B$3$N>l9g(B PostgreSQL $B$OJQ49$G$-$J$$%3!<%I$r(B 16$B?JI=8=$KJQ49$7$F$7$^$$(B
139163
$B$^$9!#$?$H$($P!"(B"(bdae)" $B$N$h$&$K!#$J$*!"$3$N(B 16$B?JI=8=$O(B mule
140-
internalcode $B$N%3!<%I$G$"$k$3$H$KCm0U$7$F2<$5$$!#$3$l$O!"D>@\%/%i%$(B
141-
$B%"%s%H(B <--> $B%5!<%P$NJ8;z%3!<%I$rJQ49$9$k$N$G$O$J$/!"0lEYFbItI=8=$G$"(B
142-
$B$k(B mule internal code $B$r7PM3$7$F$$$k$?$a$G$9!#(B
164+
internalcode $B$N%3!<%I$G$"$k$3$H$KCm0U$7$F2<$5$$!#$3$l$O!"D>@\%U%m%s(B
165+
$B%H%(%s%I(B <--> $B%P%C%/%(%s%I$N%(%s%3!<%G%#%s%0$rJQ49$9$k$N$G$O$J$/!"0l(B
166+
$BEYFbItI=8=$G$"$k(B mule internal code $B$r7PM3$7$F$$$k$?$a$G$9!#(B
143167

144-
$B%/%i%$%"%s%HB&$NJ8;z%3!<%I$N@_Dj$O!"(B"set client_encoding" $B%3%^%s%I$G(B
145-
$B$b2DG=$G$9!#$?$H$($P!"(B
168+
$B%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0$N@_Dj$O!"(B"set client_encoding" $B%3(B
169+
$B%^%s%I$G$b2DG=$G$9!#$?$H$($P!"(B
146170

147171
set client_encoding to 'sjis';
148172

149-
$B$GL@<(E*$K%/%i%$%"%s%HB&$NJ8;z%3!<%I$r(B SJIS $B$K@_Dj$G$-$^$9!#<B:]!"%/(B
150-
$B%i%$%"%s%H$,%5!<%P$K@\B3$9$k:]$K$O(B libpq $B$NCf$G(B "set
173+
$B$G%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0$r(B SJIS $B$K@_Dj$G$-$^$9!#<B:]!"%/(B
174+
$B%i%$%"%s%H$,%P%C%/%(%s%I$K@\B3$9$k:]$K$O(B libpq $B$NCf$G(B "set
151175
client_encoding" $B%3%^%s%I$rH/9T$7$F$$$^$9!#%;%C%7%g%sCf$K(B
152-
set client_encoding" $B%3%^%s%I$rH/9T$9$l$P!"F0E*$KJ8;z%3!<%I$N@ZBX$((B
153-
$B$,$G$-$^$9$,!"$=$N:]$K$O4D6-JQ?t(B PGCLIENTENCODING $B$rF1;~$K%/%i%$%"%s(B
154-
$B%H%"%W%j%1!<%7%g%s$NCf$G@_Dj$7D>$9I,MW$,$"$j$^$9!#(B(psql $B$K$O8=:_$3$N(B
155-
$B5!G=$,$J$$$?$a!";v<B>eF0E*$K%/%i%$%"%s%HB&$NJ8;z%3!<%I$r@_Dj$9$k$3$H(B
156-
$B$,$G$-$^$;$s!#(B)
176+
set client_encoding" $B%3%^%s%I$rH/9T$9$l$P!"F0E*$K%(%s%3!<%G%#%s%0$N@ZBX$((B
177+
$B$,$G$-$^$9$,!"$=$N:]$K$O4D6-JQ?t(B PGCLIENTENCODING $B$rF1;~$K%U%m%s%H%((B
178+
$B%s%I%"%W%j%1!<%7%g%s$NCf$G@_Dj$7D>$9I,MW$,$"$j$^$9!#(B(psql $B$K$O8=:_$3(B
179+
$B$N5!G=$,$J$$$?$a!";v<B>eF0E*$K%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0$r@_(B
180+
$BDj$9$k$3$H$,$G$-$^$;$s!#(B)
157181

158-
$B8=:_@_Dj$5$l$F$$$k%/%i%$%"%s%HB&$NJ8;z%3!<%I$O(B
182+
$B8=:_@_Dj$5$l$F$$$k%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0$O(B
159183

160184
show client_encoding;
161185

162186
$B$G;2>H$G$-$^$9!#$^$?!"(B
163187

164188
reset client_encoding;
165189

166-
$B$O!"%G%U%)%k%H$N%/%i%$%"%s%HJ8;z%3!<%I@_Dj$KI|5"$5$;$^$9!#(Bpostmaster
167-
$B$rN)$A>e$2$k$H$-$K4D6-JQ?t(B PGCLIENTENCODING $B$,@_Dj$5$l$F$$$k$H$=$NJ8(B
168-
$B;z%3!<%I$K!"$=$&$G$J$1$l$P%3%s%Q%$%k;~$K;XDj$7$?%5!<%PB&$NJ8;z%3!<%I(B
169-
$B$HF1$8$K$J$j$^$9!#(B
190+
$B$O!"%G%U%)%k%H$N%U%m%s%H%(%s%I%(%s%3!<%G%#%s%0@_Dj$KI|5"$5$;$^$9!#(B
191+
postmaster$B$rN)$A>e$2$k$H$-$K4D6-JQ?t(B PGCLIENTENCODING $B$,@_Dj$5$l$F$$(B
192+
$B$k$H$=$N%(%s%3!<%G%#%s%0$K!"$=$&$G$J$1$l$P%3%s%Q%$%k;~$K;XDj$7$?%P%C(B
193+
$B%/%(%s%IB&$N%(%s%3!<%G%#%s%0$HF1$8$K$J$j$^$9!#(B
170194

171195
$B@)8B;v9`!'(B
172196

173-
SJIS $B$r;HMQ$9$k>l9g!"(BPostgreSQL $B$N%/%i%$%"%s%H$G$^$H$b$KBP1~$7$F$$$k(B
197+
SJIS $B$r;HMQ$9$k>l9g!"(BPostgreSQL $B$N%U%m%s%H%(%s%I$G$^$H$b$KBP1~$7$F$$$k(B
174198
$B$N$O(B psql $B$@$1$G$9!#(BTcl/Tk$B!"$=$N$[$+$OBP1~$7$F$^$;$s!#(B
175199

176200
$B<U<-!'(B
@@ -182,10 +206,30 @@ initdb/createdb/create database $B$K$*$1$kJ8;z%3!<%I$N;XDj$K$D$$$F(B
182206

183207
$B2~DjMzNr!'(B
184208

209+
1998/12/16 $BK\%I%-%e%a%s%H=$@5!#(B
210+
* Makefile.custom $B$G(B MB=EUC_JP $B$J$I$H@_Dj$9$kJ}K!$O(B 6.4 $B0J9_(B
211+
$B%5%]!<%H$5$l$F$$$J$$$N$G:o=|$7$?!#(B
212+
* $BJ8;z%3!<%I(B $B"*(B $B%(%s%3!<%G%#%s%0!"%/%i%$%"%s%H"*%U%m%s%H%(%s%I(B
213+
$B%5!<%P"*%P%C%/%(%s%I(B $B$K$=$l$>$l8l6g$r=$@5!#(B
214+
215+
1998/12/15 6.4 $B8~$1%P%0=$@5%Q%C%A%j%j!<%9!#(B
216+
* SQL_ASCII $B%5%]!<%H$N%P%0=$@5(B
217+
218+
1998/11/21 6.4 $B8~$1%P%0=$@5%Q%C%A%j%j!<%9!#(B
219+
* BINARY CURSOR $B$NLdBj$r=$@5(B
220+
* pg_dumpall $B$N%P%0=$@5(B
221+
222+
1998/11/5 6.4 $B%j%j!<%9!#(B
223+
* pg_database $B$N(B encoding $B%+%i%`$,(B MB $B$,M-8z$G$J$$$H$-$K$b(B
224+
$BDI2C$5$l$k$h$&$K$J$C$?!#$=$N$?$a!"(BMB $B$,M-8z$G$J$$$H$-$K$O!"(B
225+
ASCII $B$N%(%s%3!<%G%#%s%0$rI=$9(B SQL_ASCII $B$r?7$7$$%(%s%3!<%G%#%s%0(B
226+
$B$H$7$FDI2C$7$?!#$3$l$K$H$b$J$$!"%(%s%3!<%G%#%s%0L>$KBP1~$9$k(B
227+
$B%(%s%3!<%G%#%s%0(BID$B$,(B SQL_ASCII $B$r(B 0 $B$H$9$kHV9f$KJQ99$K$J$C$?!#(B
228+
185229
1998/7/22 6.4 $B&A8~$1$K%Q%C%A$r%j%j!<%9!#(B
186-
* initdb/createdb/create database $B$G%5!<%PB&$NJ8;z%3!<%I$r@_Dj(B
187-
$B$G$-$k5!G=<BAu!#$3$N$?$a!"%7%9%F%`%+%?%m%0$N(B pg_database $B$K(B
188-
$B?7$7$$%+%i%`(B encoding $B$rDI2C(B(MB$B$,M-8z$J;~$@$1(B)
230+
* initdb/createdb/create database $B$G%P%C%/%(%s%IB&$N(B
231+
$B%(%s%3!<%G%#%s%0$r@_Dj$-$k5!G=<BAu!#$3$N$?$a!"%7%9%F%`%+%?%m(B
232+
$B%0$N(B pg_database$B$K?7$7$$%+%i%`(B encoding $B$rDI2C(B(MB$B$,M-8z$J;~$@$1(B)
189233
* copy $B$,(B PGCLIENTENCODING $B$KBP1~(B
190234
* SQL92 $B$N(B "SET NAMES" $B$r%5%]!<%H(B(MB$B$,M-8z$J;~$@$1(B)
191235
* LATIN2-5 $B$r%5%]!<%H(B
@@ -199,9 +243,9 @@ initdb/createdb/create database $B$K$*$1$kJ8;z%3!<%I$N;XDj$K$D$$$F(B
199243

200244
1998/5/18 $B5!G=DI2C!?%P%0=$@5(B(mb_b2.patch $B$H$7$F(B pgsql-jp ML $B$K%j%j!<%9!"(B
201245
$BK\2H$G$O(B 6.4 snapshot $B$K<h$j9~$^$l$kM=Dj(B)
202-
* $B4D6-JQ?t(B PGCLIENTENCODING $B$N%5%]!<%H!#%/%i%$%"%s%HB&$N(B
203-
$BJ8;z%3!<%I$r;XDj$9$k!#8=:_!"(BSJIS, EUC_*, MULE_INTERNAL,LATIN1
204-
$B$,;XDj$G$-$k!#$^$?!"(B
246+
* $B4D6-JQ?t(B PGCLIENTENCODING $B$N%5%]!<%H!#%U%m%s%H%(%s%IB&$N(B
247+
$B%(%s%3!<%G%#%s%0$r;XDj$9$k!#8=:_!"(BSJIS, EUC_*, MULE_INTERNAL,
248+
LATIN1$B$,;XDj$G$-$k!#$^$?!"(B
205249
set client_encoding to 'sjis';
206250
$B$G$b2DG=(B
207251
* 8bit $BJ8;z$,EO$k$HLdBj$,5/$-$k2U=j$K$G$-$k$@$1BP1~(B

‎src/bin/pgaccess/Makefile

Lines changed: 21 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,21 @@
1+
#-------------------------------------------------------------------------
2+
#
3+
# Makefile
4+
# Makefile for pgaccess
5+
#
6+
# Copyright (c) 1994, Regents of the University of California
7+
#
8+
# IDENTIFICATION
9+
# $Header: /cvsroot/pgsql/src/bin/pgaccess/Attic/Makefile,v 1.1.2.1 1998/12/18 18:01:36 momjian Exp $
10+
#
11+
#-------------------------------------------------------------------------
12+
13+
SRCDIR= ../..
14+
include$(SRCDIR)/Makefile.global
15+
16+
.PHONY: all clean
17+
allclean:
18+
19+
.PHONY: install
20+
install: pgaccess.tcl
21+
$(INSTALL)$(INSTL_EXE_OPTS) pgaccess.tcl$(BINDIR)/pgaccess

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp