3 INSERT INTO config.upgrade_log (version) VALUES ('0505'); --miker
5 CREATE OR REPLACE FUNCTION force_unicode_normal_form(string TEXT, form TEXT) RETURNS TEXT AS $func$
6 use Unicode::Normalize 'normalize';
7 return normalize($_[1],$_[0]); # reverse the params
8 $func$ LANGUAGE PLPERLU;
10 UPDATE metabib.facet_entry SET value = force_unicode_normal_form(value,'NFC');
12 CREATE OR REPLACE FUNCTION facet_force_nfc() RETURNS TRIGGER AS $$
14 NEW.value := force_unicode_normal_form(NEW.value,'NFC');
19 CREATE TRIGGER facet_force_nfc_tgr
20 BEFORE UPDATE OR INSERT ON metabib.facet_entry
21 FOR EACH ROW EXECUTE PROCEDURE facet_force_nfc();