1 DROP FUNCTION IF EXISTS public.decode_cp850(text);
2 CREATE OR REPLACE FUNCTION public.decode_cp850(text)
5 SELECT CASE WHEN $1 ~ '[^\x01-\x7F]' THEN cp850_to_utf8($1) ELSE $1 END;
7 LANGUAGE sql IMMUTABLE;
11 DROP FUNCTION IF EXISTS public.encode_cp850(text);
12 CREATE OR REPLACE FUNCTION public.encode_cp850(text)
15 SELECT CASE WHEN $1 ~ '[^\x01-\x7F]' THEN utf8_to_cp850($1) ELSE $1 END;
17 LANGUAGE sql IMMUTABLE;