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

Commit32a1a4e

Browse files
committed
document updated for 6.5.1
1 parent8f02f22 commit32a1a4e

File tree

2 files changed

+135
-7
lines changed

2 files changed

+135
-7
lines changed

‎doc/README.mb

Lines changed: 65 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
postgresql 6.5 multi-byte (MB) support READMEMar 23 1999
1+
postgresql 6.5.1 multi-byte (MB) support READMEJuly 11 1999
22

33
Tatsuo Ishii
44
t-ishii@sra.co.jp
@@ -43,8 +43,8 @@ where encoding_system is one of:
4343
LATIN4ISO 8859-4 English and some European languages
4444
LATIN5ISO 8859-5 English and some European languages
4545
KOI8KOI8-R
46-
WINCP1251
47-
ALTCP866
46+
WINWindowsCP1251
47+
ALTWindowsCP866
4848

4949
Example:
5050

@@ -125,8 +125,9 @@ Supported encodings for PGCLIENTENCODING are:
125125
LATIN4ISO 8859-4 English and some European languages
126126
LATIN5ISO 8859-5 English and some European languages
127127
KOI8KOI8-R
128-
WINCP1251
129-
ALTCP866
128+
WINWindows CP1251
129+
ALTWindows CP866
130+
WIN1250Windows CP1250 (Czech)
130131

131132
Note that UNICODE is not supported(yet). Also note that the
132133
translation is not always possible. Suppose you choose EUC_JP for the
@@ -177,6 +178,11 @@ Unicode: http://www.unicode.org/
177178

178179
5. History
179180

181+
July 11, 1999
182+
* Add support for WIN1250 (Windows Czech) as a client encoding
183+
(contributed by Pavel Behal)
184+
* fix some compiler warnings (contributed by Tomoaki Nishiyama)
185+
180186
Mar 23, 1999
181187
* Add support for KOI8(KOI8-R), WIN(CP1251), ALT(CP866)
182188
(thanks Oleg Broytmann for testing)
@@ -230,3 +236,57 @@ Mar 10, 1998 PL2 released
230236
* fix problems concerning 8-bit single byte characters
231237

232238
Mar 1, 1998 PL1 released
239+
240+
Appendix:
241+
242+
[Here is a good documentation explaining how to use WIN1250 on
243+
Windows/ODBC from Pavel Behal. Please note that Installation step 1)
244+
is not necceary in 6.5.1 -- Tatsuo]
245+
246+
Version: 0.91 for PgSQL 6.5
247+
Author: Pavel Behal
248+
Revised by: Tatsuo Ishii
249+
Email: behal@opf.slu.cz
250+
Licence: The Same as PostgreSQL
251+
252+
Sorry for my Eglish and C code, I'm not native :-)
253+
254+
!!!!!!!!!!!!!!!!!!!!!!!!! NO WARRANTY !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
255+
256+
Instalation:
257+
------------
258+
1) Change three affected files in source directories
259+
(I don't have time to create proper patch diffs, I don't know how)
260+
2) Compile with enabled locale and multibyte set to LATIN2
261+
3) Setup properly your instalation, do not forget to create locale
262+
variables in your profile (environment). Ex. (may not be exactly true):
263+
LC_ALL=cs_CZ.ISO8859-2
264+
LC_COLLATE=cs_CZ.ISO8859-2
265+
LC_CTYPE=cs_CZ.ISO8859-2
266+
LC_MONETARY=cs_CZ.ISO8859-2
267+
LC_NUMERIC=cs_CZ.ISO8859-2
268+
LC_TIME=cs_CZ.ISO8859-2
269+
4) You have to start the postmaster with locales set!
270+
5) Try it with Czech language, it have to sort
271+
5) Install ODBC driver for PgSQL into your M$ Windows
272+
6) Setup properly your data source. Include this line in your ODBC
273+
configuration dialog in field "Connect Settings:" :
274+
SET CLIENT_ENCODING = 'WIN1250';
275+
7) Now try it again, but in Windows with ODBC.
276+
277+
Description:
278+
------------
279+
- Depends on proper system locales, tested with RH6.0 and Slackware 3.6,
280+
with cs_CZ.iso8859-2 loacle
281+
- Never try to set-up server multibyte database encoding to WIN1250,
282+
always use LATIN2 instead. There is not WIN1250 locale in Unix
283+
- WIN1250 encoding is useable only for M$W ODBC clients. The characters are
284+
on thy fly re-coded, to be displayed and stored back properly
285+
286+
Important:
287+
----------
288+
- it reorders your sort order depending on your LC_... setting, so don't be
289+
confused with regression tests, they don't use locale
290+
- "ch" is corectly sorted only in some newer locales (Ex. RH6.0)
291+
- you have to insert money as '162,50' (with comma in aphostrophes!)
292+
- not tested properly

‎doc/README.mb.jp

Lines changed: 70 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
postgresql 6.5 multi-byte (MB) support README 1999/3/23 $B:n@.(B
1+
postgresql 6.5.1 multi-byte (MB) support README 1999/7/11 $B:n@.(B
22

33
$B@P0fC#IW(B
44
t-ishii@sra.co.jp
@@ -144,7 +144,8 @@ initdb/createdb/create database $B$K$*$1$k%(%s%3!<%G%#%s%0$N;XDj$K$D$$$F(B
144144

145145
$B4D6-JQ?t(B PGCLIENTENCODING $B$,@_Dj$5$l$F$$$k>l9g$O$=$NCM$,M%@h$5$l!"%P%C(B
146146
$B%/%(%s%IB&$H0[$J$k%(%s%3!<%G%#%s%0$,;HMQ$G$-$^$9!#@_Dj2DG=$J%(%s%3!<(B
147-
$B%G%#%s%0$O!">e5-$K2C$(!"(BSJIS ($B%7%U%H(BJIS)$B$H(B BiG5 $B$,;XDj$G$-$^$9!#(B
147+
$B%G%#%s%0$O!">e5-$K2C$(!"(BSJIS ($B%7%U%H(BJIS)$B!"(BBiG5 $B$=$l$K(B WIN1250
148+
(Windows$BMQ$N%A%'%38l(B)$B$,;XDj$G$-$^$9!#(B
148149

149150
$B$A$J$_$K!"(BSJIS $B$O(B JISX0201 $B$N(B 1$B%P%$%H%+%J!"$$$o$f$k!VH>3Q%+%?(B
150151
$B%+%J!W$b%5%]!<%H$7$F$$$^$9(B($B7h$7$F!VH>3Q%+%?%+%J!W$N;HMQ$r$*4+(B
@@ -218,8 +219,75 @@ initdb/createdb/create database $B$K$*$1$k%(%s%3!<%G%#%s%0$N;XDj$K$D$$$F(B
218219
$B$^$?!"(BSJIS $BBP1~$K$D$$$F$O!";T@n(B@$B$*CcBg$5$s$N%Q%C%A$r;29M$K$5$;$F$$(B
219220
$B$?$@$-$^$7$?!#(B
220221

222+
$B;29M!'(B
223+
224+
Pavel Behal$B;a$K$h$jDs6!$5$l$?(BWIN1250$B%5%]!<%H$G$9$,!"(BWindows$B4D6-$G$N(B
225+
$BMxMQ$N;EJ}$K$D$$$F;29M$K$J$k%I%-%e%a%s%H$,IUB0$7$F$$$k$N$G!"$3$3$KE:(B
226+
$BIU$7$F$*$-$^$9!#(B
227+
228+
-------------------------------------------------------------------
229+
Version: 0.91 for PgSQL 6.5
230+
Author: Pavel Behal
231+
Revised by: Tatsuo Ishii
232+
Email: behal@opf.slu.cz
233+
Licence: The Same as PostgreSQL
234+
235+
Sorry for my Eglish and C code, I'm not native :-)
236+
237+
!!!!!!!!!!!!!!!!!!!!!!!!! NO WARRANTY !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
238+
239+
Instalation:
240+
------------
241+
1) Change three affected files in source directories
242+
(I don't have time to create proper patch diffs, I don't know how)
243+
[PostgreSQL 6.5.1$B$G$O$3$N%9%F%C%W$OI,MW$"$j$^$;$s!#(B-- $B@P0f(B]
244+
2) Compile with enabled locale and multibyte set to LATIN2
245+
3) Setup properly your instalation, do not forget to create locale
246+
variables in your profile (environment). Ex. (may not be exactly true):
247+
LC_ALL=cs_CZ.ISO8859-2
248+
LC_COLLATE=cs_CZ.ISO8859-2
249+
LC_CTYPE=cs_CZ.ISO8859-2
250+
LC_MONETARY=cs_CZ.ISO8859-2
251+
LC_NUMERIC=cs_CZ.ISO8859-2
252+
LC_TIME=cs_CZ.ISO8859-2
253+
4) You have to start the postmaster with locales set!
254+
5) Try it with Czech language, it have to sort
255+
5) Install ODBC driver for PgSQL into your M$ Windows
256+
6) Setup properly your data source. Include this line in your ODBC
257+
configuration dialog in field "Connect Settings:" :
258+
SET CLIENT_ENCODING = 'WIN1250';
259+
7) Now try it again, but in Windows with ODBC.
260+
261+
Description:
262+
------------
263+
- Depends on proper system locales, tested with RH6.0 and Slackware 3.6,
264+
with cs_CZ.iso8859-2 loacle
265+
- Never try to set-up server multibyte database encoding to WIN1250,
266+
always use LATIN2 instead. There is not WIN1250 locale in Unix
267+
- WIN1250 encoding is useable only for M$W ODBC clients. The characters are
268+
on thy fly re-coded, to be displayed and stored back properly
269+
270+
Important:
271+
----------
272+
- it reorders your sort order depending on your LC_... setting, so don't be
273+
confused with regression tests, they don't use locale
274+
- "ch" is corectly sorted only in some newer locales (Ex. RH6.0)
275+
- you have to insert money as '162,50' (with comma in aphostrophes!)
276+
- not tested properly
277+
-------------------------------------------------------------------
278+
279+
221280
$B2~DjMzNr!'(B
222281

282+
1999/7/11 WIN1250(Windows$BMQ$N%A%'%38l(B)$B%5%]!<%H$rDI2C$7$^$7$?!#(B
283+
* WIN1250 $B$,%U%m%s%H%(%s%IB&$N%(%s%3!<%G%#%s%0$H$7$FMxMQ$G$-$k$h(B
284+
$B$&$K$J$j$^$7$?!#$3$N>l9g!"%P%C%/%(%s%IB&$N%(%s%3!<%G%#%s%0$O(B
285+
LATIN2 $B$^$?$O(B MULE_INTERNAL $B$H$7$^$9!#(B
286+
(contributed by Pavel Behal)
287+
* backend/utils/mb/conv.c$B$K$*$1$k7?$NIT@09g$r=$@5$7$^$7$?!#(B
288+
(contributed by Tomoaki Nishiyama)
289+
* $B$3$l$i$O(B6.5.1$B$KH?1G$5$l$^$9!#(B
290+
223291
1999/3/23 $B%-%j%kJ8;z%5%]!<%HDI2CB>(B(6.5 $B$KH?1G:Q(B)
224292
* $B%(%s%3!<%G%#%s%0$H$7$F(B KOI8(KOI8-R), WIN(CP1251), ALT(CP866) $B$r(B
225293
$B%5%]!<%H$7$F$$$^$9!#$3$l$i$O!"%U%m%s%H%(%s%I!"%P%C%/%(%s%I!"(B

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp