In this example I change turkish character set of name field from turkish to english words
select replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(name,'ü','u'),'ö','o'),'ı','i'),'ç','c'),'ş','s'),'ğ','g'),' ','-'),'.',''),'(','_'),')',''),',','') from geo_unit