LP#1501781 - Make patron name search diacritic/space insensitive. user/kmlussier/lp1501781-accent3
authorDan Pearl <dpearl@cwmars.org>
Thu, 1 Oct 2015 13:49:17 +0000 (09:49 -0400)
committerKathy Lussier <klussier@masslnc.org>
Thu, 3 Mar 2016 02:06:25 +0000 (21:06 -0500)
commita1ef86927cd435b8d47a231f5c29ed9861b18f2f
treedc8453a883a66d756267ef40283b7228bfe62d9e
parentb3ebb9c9264c595e70cfb7daa74917b14de06d60
LP#1501781 - Make patron name search diacritic/space insensitive.

Diacritical marks may exist in the patron record -- as they should, but this makes patron name search difficult
for librarians who may be unfamiliar with all the special characters used and also how to elicit them from a
keyboard.  To ease this, accented characters will be converted into their 'plain' analogs for comparison purposes.

So, for example, if the patron's last name is Chávez, typing "Chavez" in the Last Name box in Patron Search will
match it.

Spaces in a name (like "De la Croix") will be squashed out so that name would be matched by "Delacroix" or "De la Croix" or variants.

The librarian can enter the accented characters or not.

Signed-off-by: Dan Pearl <dpearl@cwmars.org>
Conflicts:
Open-ILS/src/sql/Pg/create_database_extensions.sql
13 files changed:
Open-ILS/src/extras/install/Makefile.debian-jessie
Open-ILS/src/extras/install/Makefile.debian-squeeze
Open-ILS/src/extras/install/Makefile.debian-wheezy
Open-ILS/src/extras/install/Makefile.fedora
Open-ILS/src/extras/install/Makefile.ubuntu-precise
Open-ILS/src/extras/install/Makefile.ubuntu-trusty
Open-ILS/src/perlmods/Build.PL
Open-ILS/src/perlmods/lib/OpenILS/Application/Storage/Publisher/actor.pm
Open-ILS/src/sql/Pg/005.schema.actors.sql
Open-ILS/src/sql/Pg/950.data.seed-values.sql
Open-ILS/src/sql/Pg/create_database_extensions.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.patron_unaccent.sql [new file with mode: 0644]
docs/RELEASE_NOTES_NEXT/Client/accent_insensitive_patron_search [new file with mode: 0644]