From 0dcbb8652b4613967901b44cf5e3b53d7c122a2a Mon Sep 17 00:00:00 2001
From: Bill Erickson <berickxx@gmail.com>
Date: Thu, 3 Mar 2016 18:04:18 -0500
Subject: [PATCH] JBAS-1284 Strip apostrophes in search normalize
MIME-Version: 1.0
Content-Type: text/plain; charset=utf8
Content-Transfer-Encoding: 8bit

Test case is title search for both forms:

ha-na'arah she-sihkah ba-esh
ha-Naʻarah she-śiḥḳah ba-esh

Signed-off-by: Bill Erickson <berickxx@gmail.com>
---
 KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql b/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql
index 2bdd0e360e..96c11bebed 100644
--- a/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql
+++ b/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql
@@ -394,6 +394,9 @@ CREATE OR REPLACE FUNCTION public.search_normalize( TEXT, TEXT ) RETURNS TEXT AS
     # transformations based on Unicode category codes
     $str =~ s/[\p{Cc}\p{Cf}\p{Co}\p{Cs}\p{Lm}\p{Mc}\p{Me}\p{Mn}]//g;
 
+    # JBAS-1284 Strip apostrophes
+    $str =~ s/\'//g;
+
 	if ($sf && $sf =~ /^a/o) {
 		my $commapos = index($str, ',');
 		if ($commapos > -1) {
-- 
2.11.0