CREATE OR REPLACE FUNCTION s_get_nocase_text (text) RETURNS text AS $$ SELECT translate(upper($1) ,'−ï¼ãƒ¼â€•-0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ ' ,'â€â€â€â€â€ï¼ï¼‘23456789ABCDEFGHIJKLï¼ï¼®ï¼¯ï¼°ï¼±ï¼²ï¼³ï¼´ï¼µï¼¶ï¼·ï¼¸ï¼¹ï¼ºã€€'); $$ LANGUAGE SQL IMMUTABLE;