Keeping track of custom unaccent rules could become tricky if the Pg module changes, or if there are differences for other languages, too.
Besides writing unaccent_and_squash() in PL/Perl, we could add an open-ils.storage call to unaccent a string using the unaccent extension as well as another to call unaccent and squash on a string.
It may be necessary to a more public call in some other service, maybe open-ils.actor, to work on names so it can be used where the private router is not available.
Keeping track of custom unaccent rules could become tricky if the Pg module changes, or if there are differences for other languages, too.
Besides writing unaccent_ and_squash( ) in PL/Perl, we could add an open-ils.storage call to unaccent a string using the unaccent extension as well as another to call unaccent and squash on a string.
It may be necessary to a more public call in some other service, maybe open-ils.actor, to work on names so it can be used where the private router is not available.
Just a thought.