Skip to content

Commit 3c7798f

Browse files
tatsuo-ishiitatsuo-ishii
committed
Add conversion procs for CREATE CONVERSION
1 parent 743b747 commit 3c7798f

File tree

36 files changed

+2954
-0
lines changed

36 files changed

+2954
-0
lines changed

‎src/backend/utils/mb/conversion_procs/Makefile

Lines changed: 118 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,118 @@
1+
#-------------------------------------------------------------------------
2+
#
3+
# Makefile--
4+
# Makefile for utils/mb/conversion_procs
5+
#
6+
# IDENTIFICATION
7+
# $Header: /cvsroot/pgsql/src/backend/utils/mb/conversion_procs/Makefile,v 1.1 2002/07/16 09:25:04 ishii Exp $
8+
#
9+
#-------------------------------------------------------------------------
10+
11+
subdir = src/backend/utils/mb/conversion_procs
12+
top_builddir = ../../../../..
13+
include $(top_builddir)/src/Makefile.global
14+
15+
SQLSCRIPT = conversion_create.sql
16+
17+
DIRS = \
18+
utf8_and_ascii utf8_and_iso8859_1 \
19+
utf8_and_euc_jp utf8_and_euc_kr utf8_and_euc_cn utf8_and_euc_tw \
20+
utf8_and_sjis utf8_and_big5 utf8_and_gbk utf8_and_gb18030 \
21+
utf8_and_uhc utf8_and_johab utf8_and_tcvn utf8_and_iso8859 \
22+
euc_jp_and_sjis euc_tw_and_big5
23+
24+
# conversion_name source_encoding destination_encoding function object
25+
$(SQLSCRIPT): Makefile
26+
@set \
27+
utf8_to_ascii UNICODE SQL_ASCII utf8_to_ascii utf8_and_ascii \
28+
ascii_to_utf8 SQL_ASCII UNICODE ascii_to_utf8 utf8_and_ascii \
29+
utf8_to_iso8859_1 UNICODE LATIN1 utf8_to_iso8859_1 utf8_and_iso8859_1 \
30+
iso8859_1_to_utf8 LATIN1 UNICODE iso8859_1_to_utf8 utf8_and_iso8859_1 \
31+
euc_jp_to_utf8 EUC_JP UNICODE euc_jp_to_utf8 utf8_and_euc_jp \
32+
utf8_to_euc_jp UNICODE EUC_JP utf8_to_euc_jp utf8_and_euc_jp \
33+
euc_kr_to_utf8 EUC_KR UNICODE euc_kr_to_utf8 utf8_and_euc_kr \
34+
utf8_to_euc_kr UNICODE EUC_KR utf8_to_euc_kr utf8_and_euc_kr \
35+
euc_cn_to_utf8 EUC_CN UNICODE euc_cn_to_utf8 utf8_and_euc_cn \
36+
utf8_to_euc_cn UNICODE EUC_CN utf8_to_euc_cn utf8_and_euc_cn \
37+
euc_tw_to_utf8 EUC_TW UNICODE euc_tw_to_utf8 utf8_and_euc_tw \
38+
utf8_to_euc_tw UNICODE EUC_TW utf8_to_euc_tw utf8_and_euc_tw \
39+
sjis_to_utf8 SJIS UNICODE sjis_to_utf8 utf8_and_sjis \
40+
utf8_to_sjis UNICODE SJIS utf8_to_sjis utf8_and_sjis \
41+
big5_to_utf8 BIG5 UNICODE big5_to_utf8 utf8_and_big5 \
42+
utf8_to_big5 UNICODE BIG5 utf8_to_big5 utf8_and_big5 \
43+
gbk_to_utf8 GBK UNICODE gbk_to_utf8 utf8_and_gbk \
44+
utf8_to_gbk UNICODE GBK utf8_to_gbk utf8_and_gbk \
45+
gb18030_to_utf8 GB18030 UNICODE gb18030_to_utf8 utf8_and_gb18030 \
46+
utf8_to_gb18030 UNICODE GB18030 utf8_to_gb18030 utf8_and_gb18030 \
47+
uhc_to_utf8 UHC UNICODE uhc_to_utf8 utf8_and_uhc \
48+
utf8_to_uhc UNICODE UHC utf8_to_uhc utf8_and_uhc \
49+
johab_to_utf8 JOHAB UNICODE johab_to_utf8 utf8_and_johab \
50+
utf8_to_johab UNICODE JOHAB utf8_to_johab utf8_and_johab \
51+
tcvn_to_utf8 TCVN UNICODE tcvn_to_utf8 utf8_and_tcvn \
52+
utf8_to_tcvn UNICODE TCVN utf8_to_tcvn utf8_and_tcvn \
53+
utf8_to_iso8859_2 UNICODE LATIN2 utf8_to_iso8859 utf8_and_iso8859 \
54+
iso8859_2_to_utf8 LATIN2 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
55+
utf8_to_iso8859_3 UNICODE LATIN3 utf8_to_iso8859 utf8_and_iso8859 \
56+
iso8859_3_to_utf8 LATIN3 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
57+
utf8_to_iso8859_4 UNICODE LATIN4 utf8_to_iso8859 utf8_and_iso8859 \
58+
iso8859_4_to_utf8 LATIN4 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
59+
utf8_to_iso8859_9 UNICODE LATIN5 utf8_to_iso8859 utf8_and_iso8859 \
60+
iso8859_9_to_utf8 LATIN5 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
61+
utf8_to_iso8859_10 UNICODE LATIN6 utf8_to_iso8859 utf8_and_iso8859 \
62+
iso8859_10_to_utf8 LATIN6 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
63+
utf8_to_iso8859_13 UNICODE LATIN7 utf8_to_iso8859 utf8_and_iso8859 \
64+
iso8859_13_to_utf8 LATIN7 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
65+
utf8_to_iso8859_14 UNICODE LATIN8 utf8_to_iso8859 utf8_and_iso8859 \
66+
iso8859_14_to_utf8 LATIN8 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
67+
utf8_to_iso8859_15 UNICODE LATIN9 utf8_to_iso8859 utf8_and_iso8859 \
68+
iso8859_15_to_utf8 LATIN9 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
69+
utf8_to_iso8859_16 UNICODE LATIN10 utf8_to_iso8859 utf8_and_iso8859 \
70+
iso8859_16_to_utf8 LATIN10 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
71+
utf8_to_iso8859_5 UNICODE ISO-8859-5 utf8_to_iso8859 utf8_and_iso8859 \
72+
iso8859_5_to_utf8 ISO-8859-5 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
73+
utf8_to_iso8859_6 UNICODE ISO-8859-6 utf8_to_iso8859 utf8_and_iso8859 \
74+
iso8859_6_to_utf8 ISO-8859-6 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
75+
utf8_to_iso8859_7 UNICODE ISO-8859-7 utf8_to_iso8859 utf8_and_iso8859 \
76+
iso8859_7_to_utf8 ISO-8859-7 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
77+
utf8_to_iso8859_8 UNICODE ISO-8859-8 utf8_to_iso8859 utf8_and_iso8859 \
78+
iso8859_8_to_utf8 ISO-8859-8 UNICODE iso8859_to_utf8 utf8_and_iso8859 \
79+
euc_jp_to_sjis EUC_JP SJIS euc_jp_to_sjis euc_jp_and_sjis \
80+
sjis_to_euc_jp SJIS EUC_JP sjis_to_euc_jp euc_jp_and_sjis \
81+
euc_jp_to_mic EUC_JP MULE_INTERNAL euc_jp_to_mic euc_jp_and_sjis \
82+
sjis_to_mic SJIS MULE_INTERNAL sjis_to_mic euc_jp_and_sjis \
83+
mic_to_euc_jp MULE_INTERNAL EUC_JP mic_to_euc_jp euc_jp_and_sjis \
84+
mic_to_sjis MULE_INTERNAL SJIS mic_to_sjis euc_jp_and_sjis \
85+
euc_tw_to_big5 EUC_TW BIG5 euc_tw_to_big5 euc_tw_and_big5 \
86+
big5_to_euc_tw BIG5 EUC_TW big5_to_euc_tw euc_tw_and_big5 \
87+
euc_tw_to_mic EUC_TW MULE_INTERNAL euc_tw_to_mic euc_tw_and_big5 \
88+
big5_to_mic BIG5 MULE_INTERNAL big5_to_mic euc_tw_and_big5 \
89+
mic_to_euc_tw MULE_INTERNAL EUC_TW mic_to_euc_tw euc_tw_and_big5 \
90+
mic_to_big5 MULE_INTERNAL BIG5 mic_to_big5 euc_tw_and_big5 \
91+
; \
92+
while [ "$$#" -gt 0 ] ; \
93+
do \
94+
name=$$1;shift; \
95+
se=$$1;shift; \
96+
de=$$1; shift; \
97+
func=$$1; shift; \
98+
obj=$$1; shift; \
99+
echo "-- $$se --> $$de"; \
100+
echo "CREATE OR REPLACE FUNCTION $$func (INTEGER, INTEGER, OPAQUE, OPAQUE, INTEGER) RETURNS INTEGER AS '$$"libdir"/$$obj', '$$func' LANGUAGE 'c';"; \
101+
echo "DROP CONVERSION pg_catalog.$$name;"; \
102+
echo "CREATE DEFAULT CONVERSION pg_catalog.$$name FOR '$$se' TO '$$de' FROM $$func;"; \
103+
done > $@
104+
105+
install:
106+
$(INSTALL_DATA) $(SQLSCRIPT) $(datadir)
107+
@for dir in $(DIRS); do $(MAKE) -C $$dir $@ || exit; done
108+
109+
all: $(SQLSCRIPT)
110+
@for dir in $(DIRS); do $(MAKE) -C $$dir $@ || exit; done
111+
112+
clean:
113+
$(RM) $(SQLSCRIPT)
114+
@for dir in $(DIRS); do $(MAKE) -C $$dir $@; done
115+
116+
distclean maintainer-clean:
117+
$(RM) $(SQLSCRIPT)
118+
@for dir in $(DIRS); do $(MAKE) -C $$dir $@; done

‎src/backend/utils/mb/conversion_procs/euc_jp_and_sjis/Makefile

Lines changed: 11 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -0,0 +1,11 @@
1+
#-------------------------------------------------------------------------
2+
#
3+
# $Id: Makefile,v 1.1 2002/07/16 09:25:05 ishii Exp $
4+
#
5+
#-------------------------------------------------------------------------
6+
top_builddir = ../../../../../..
7+
include $(top_builddir)/src/Makefile.global
8+
9+
NAME := euc_jp_and_sjis
10+
11+
include ../proc.mk

0 commit comments

Comments
 (0)