-
Notifications
You must be signed in to change notification settings - Fork 1
/
codepage_850.plpythonu
54 lines (47 loc) · 1.61 KB
/
codepage_850.plpythonu
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
--
-- Glyn Astill 09/02/2014
-- Plpython untrusted functions to do conversion from DOS cp850 native through Latin1 to UTF8 and vice versa
--
CREATE OR REPLACE FUNCTION cp850_to_utf8(in_text text) RETURNS text AS
$BODY$
rv = plpy.execute("SHOW client_encoding", 1)
v_encoding = rv[0]["client_encoding"]
if v_encoding.upper() != 'UTF8':
raise plpy.Error('Sorry client_encoding should be UTF8')
else:
return unicode(in_text, 'cp850').encode('iso8859_1')
$BODY$
LANGUAGE plpythonu;
--
CREATE OR REPLACE FUNCTION utf8_to_cp850(in_text text) RETURNS text AS
$BODY$
rv = plpy.execute("SHOW client_encoding", 1)
v_encoding = rv[0]["client_encoding"]
if v_encoding.upper() != 'UTF8':
raise plpy.Error('Sorry client_encoding should be UTF8')
else:
return unicode(in_text, 'iso8859_1').encode('cp850')
$BODY$
LANGUAGE plpythonu;
--
CREATE OR REPLACE FUNCTION cp850_to_latin1(in_text text) RETURNS text AS
$BODY$
rv = plpy.execute("SHOW client_encoding", 1)
v_encoding = rv[0]["client_encoding"]
if v_encoding.upper() != 'LATIN1':
raise plpy.Error('Sorry client_encoding should be LATIN1')
else:
return unicode(in_text, 'cp850').encode('utf-8')
$BODY$
LANGUAGE plpythonu;
--
CREATE OR REPLACE FUNCTION latin1_to_cp850(in_text text) RETURNS text AS
$BODY$
rv = plpy.execute("SHOW client_encoding", 1)
v_encoding = rv[0]["client_encoding"]
if v_encoding.upper() != 'LATIN1':
raise plpy.Error('Sorry client_encoding should be LATIN1')
else:
return unicode(in_text, 'utf-8').encode('cp850')
$BODY$
LANGUAGE plpythonu;