From 44d260c577e133410b07f6569dd9ca51e28d7c27 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Fri, 6 May 2011 12:58:17 -0400 Subject: [PATCH] Use unicode escape instead of raw bytes, for ease of maintenance --- Open-ILS/src/sql/Pg/020.schema.functions.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/020.schema.functions.sql b/Open-ILS/src/sql/Pg/020.schema.functions.sql index 569344303e..f894076c58 100644 --- a/Open-ILS/src/sql/Pg/020.schema.functions.sql +++ b/Open-ILS/src/sql/Pg/020.schema.functions.sql @@ -357,7 +357,7 @@ BEGIN FOR sf IN SELECT * FROM regexp_split_to_table(acsaf.sf_list,'') LOOP tmp_text := oils_xpath_string('//*[@tag="'||tag_used||'"]/*[@code="'||sf||'"]', marcxml); IF tmp_text IS NOT NULL THEN - heading_text := heading_text || E'‡' || sf || ' ' || tmp_text; + heading_text := heading_text || E'\U2021' || sf || ' ' || tmp_text; END IF; END LOOP; EXIT WHEN heading_text <> ''; -- 2.11.0