Remove accents SQL

removeaccents.sql

drop function if exists fn_remove_accents;
delimiter |
create function fn_remove_accents( textvalue varchar(20000) )
returns varchar(20000)
begin

set @textvalue = textvalue;

-- ACCENTS
set @withaccents =    'ĎŇňŘřČ莞ĽľĚ슚ŽžÀÁÂÃÄÅÆÇÈÉÊËÌÍÎÏÑÒÓÔÕÖØßÙÚÛÜŮÝŸÞàáâãäåæçèéêëìíîïñòóôõöøùúûüůýÿþƒ';
set @withoutaccents = 'DdTtNnRrCcZzLlEeSsZzAAAAAAACEEEEIIIINOOOOOOsUUUUUYYBaaaaaaaceeeeiiiinoooooouuuuuyybf';
set @count = length(@withaccents);

while @count > 0 do
    set @textvalue = replace(@textvalue, substring(@withaccents, @count, 1), substring(@withoutaccents, @count, 1));
    set @count = @count - 1;
end while;

-- SPECIAL CHARS
set @special = '!@#$%¨&*()_+=§¹²³£¢¬"`´{[^~}]<,>.:;?/°ºª+*|\\''';
set @count = length(@special);
while @count > 0 do
    set @textvalue = replace(@textvalue, substring(@special, @count, 1), '');
    set @count = @count - 1;
end while;

return @textvalue;

end
|