Differences

This shows you the differences between two versions of the page.

--- scratchpad:brush_up_search [2016/04/23 20:09] – created klussier
+++ scratchpad:brush_up_search [2016/05/13 14:21] – [Apostrophe Searching] klussier
@@ Line 5: / Line 5: @@
 **The problem:** Evergreen uses a modified NACO normalization scheme to better handle apostrophe searching for French records. The problem is that this normalization scheme doesn't work as well for English records as pure NACO normalization does. It also sometimes relies on stemming to find the correct search term, which causes problems for sites that disabled stemming
-**Who should consider this tweak:** Evergreen sites where the majority of records are in English and are okay with search behavior where a search for a French word like 'histoire' will not retrieve records with l'histoire. There may be other multi-lingual implications for this making this tweak. Sites that have disabled stemming should strongly consider this tweak.
+**Who should consider this tweak:** Evergreen sites with a database the mostly contain English-language records and that are okay with search behavior where a search for a French word like 'histoire' will not retrieve records with l'histoire. There may be other multi-lingual implications for making this tweak. Sites with mostly English records that have also disabled stemming should strongly consider this tweak.
 **How To:**
-  - Add mappings to NACO Normalize for all indexes that are currently mapped to the default Search Normalize function.
+Add mappings to NACO Normalize for all indexes that are currently mapped to the default Search Normalize function.
+<code sql>
+UPDATE config.metabib_field_index_norm_map a
+SET norm = 1
+FROM (SELECT norm FROM config.metabib_field_index_norm_map) AS subquery
+WHERE subquery.norm = 17 and a.id = subquery.id;
+</code>
+A [[scratchpad:random_magic_spells#reingesting_bib_and_authority_records_20_and_later|full reingest]] is required after making this adjustment.