Thom Brown escribió: > Here's an example of a function I might use (although I haven't actually got > plperl installed, so can't test it myself, but you'll get the idea: > > CREATE OR REPLACE FUNCTION unaccent_string(text) RETURNS text AS $$ > my ($input_string) = @_; > $input_string =~ s/[âãäåāăą]/a; > $input_string =~ s/[ÁÂÃÄÅĀĂĄ]/A; Hmm, if to_ascii() doesn't work, that's something worth some research. Maybe the encoding config is broken, for example. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support - Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
