X-Git-Url: https://git.8kb.co.uk/?p=postgresql%2Fencoding_woes;a=blobdiff_plain;f=codepage_850.sql;fp=codepage_850.sql;h=4661a597901f8af8968bd875cf32f8df51b22819;hp=0000000000000000000000000000000000000000;hb=f3bac31311dbff89e2f8683741c8a8aa492259a5;hpb=12e8a65141adc17bfa62f52b852d9f81fe02c3c6

diff --git a/codepage_850.sql b/codepage_850.sql
new file mode 100644
index 0000000..4661a59
--- /dev/null
+++ b/codepage_850.sql
@@ -0,0 +1,17 @@
+DROP FUNCTION IF EXISTS public.decode_cp850(text);
+CREATE OR REPLACE FUNCTION public.decode_cp850(text)
+RETURNS text AS
+$BODY$
+    SELECT CASE WHEN $1 ~ '[^\x01-\x7F]' THEN cp850_to_utf8($1) ELSE $1 END;        
+$BODY$
+LANGUAGE sql IMMUTABLE;
+
+--
+
+DROP FUNCTION IF EXISTS public.encode_cp850(text);
+CREATE OR REPLACE FUNCTION public.encode_cp850(text)
+RETURNS text AS
+$BODY$
+    SELECT CASE WHEN $1 ~ '[^\x01-\x7F]' THEN utf8_to_cp850($1) ELSE $1 END;        
+$BODY$
+LANGUAGE sql IMMUTABLE;