From 4ef4d7472cfc902ecf787a09ca607408f4dfd035 Mon Sep 17 00:00:00 2001
From: Chris Sharp <csharp@georgialibraries.org>
Date: Tue, 6 Dec 2011 08:44:08 -0500
Subject: [PATCH] adding lines to clean up MARC records by adding flag for
 UNICODE

---
 Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

diff --git a/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql b/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql
index 9c1a556c6a..8cf1fb3de4 100644
--- a/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql
+++ b/Open-ILS/src/sql/Pg/pines-pre-1.6.1-2.1-upgrade.sql
@@ -188,6 +188,14 @@ INSERT INTO config.metabib_field ( id, field_class, name, xpath, weight, format,
 
 COMMIT;
 
+-- we need to tell Evergreen that every record we have in the system is a Unicode record:
+
+-- disable triggers on biblio.record_entry:
+
+
+UPDATE biblio.record_entry
+    SET marc = regexp_replace(marc, E'(<leader>.{9}).', E'\\1a');
+
 
 -- These are restored by the post-upgrade PINES sql script.
 
-- 
2.11.0