Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public final class SqlUtils {
- public static String removeAcentos(String texto) {
- return texto.replaceAll("[áàãâä]", "a")
- .replaceAll("[ÁÀÃÂÄ]", "A")
- .replaceAll("[éèêë]", "e")
- .replaceAll("[ÉÈÊË]", "E")
- .replaceAll("[íìîï]", "i")
- .replaceAll("[ÍÌÎÏ]", "I")
- .replaceAll("[óòõôö]", "o")
- .replaceAll("[ÓÒÕÔÖ]", "O")
- .replaceAll("[úùûü]", "u")
- .replaceAll("[ÚÙÛÜ]", "U")
- .replaceAll("[ñ]", "n")
- .replaceAll("[Ñ]", "N")
- .replaceAll("[ç]", "c")
- .replaceAll("[Ç]", "C")
- .replaceAll("[ÿý]", "y")
- .replaceAll("[Ý]", "Y");
- }
- }
- CREATE FUNCTION removeAcentos(texto VARCHAR(100))
- RETURNS Varchar(100)
- LANGUAGE JAVA
- PARAMETER STYLE JAVA
- NO SQL
- EXTERNAL NAME 'sqlutils.SqlUtils.removeAcentos'
Add Comment
Please, Sign In to add comment