-
🌱 I’m currently working as a Full stack developer
-
👨💻 All of my projects are available at https://www.tecklens.com/
-
📝 I regularly write articles on https://www.tecklens.com/articles/
-
💬 Ask me about ReactJS, Nextjs, TypeScript, Javascript, HTML, CSS, Golang
-
📫 How to reach me [email protected]
CREATE OR REPLACE FUNCTION `remove_accents`(`str` TEXT CHARACTER SET utf8mb4 collate utf8mb4_unicode_ci )
RETURNS text CHARACTER SET utf8mb4 collate utf8mb4_unicode_ci
LANGUAGE SQL
DETERMINISTIC
NO SQL
SQL SECURITY INVOKER
COMMENT ''
BEGIN
SET str = REPLACE(str, 'Š', 'S');
SET str = REPLACE(str, 'š', 's');
SET str = REPLACE(str, 'Ð', 'Dj');
SET str = REPLACE(str, 'Ž', 'Z');
SET str = REPLACE(str, 'ž', 'z');
SET str = REPLACE(str, 'À', 'A');
SET str = REPLACE(str, 'Á', 'A');
SET str = REPLACE(str, 'Ả', 'A');
SET str = REPLACE(str, 'Ạ', 'A');
SET str = REPLACE(str, 'Ắ', 'A');
SET str = REPLACE(str, 'Ằ', 'A');
SET str = REPLACE(str, 'Ặ', 'A');
SET str = REPLACE(str, 'Ă', 'A');
SET str = REPLACE(str, 'Ẳ', 'A');
SET str = REPLACE(str, 'Â', 'A');
SET str = REPLACE(str, 'Ầ', 'A');
SET str = REPLACE(str, 'Ấ', 'A');
SET str = REPLACE(str, 'Ậ', 'A');
SET str = REPLACE(str, 'Ẩ', 'A');
SET str = REPLACE(str, 'Ẫ', 'A');
SET str = REPLACE(str, 'Ã', 'A');
SET str = REPLACE(str, 'Ä', 'A');
SET str = REPLACE(str, 'Å', 'A');
SET str = REPLACE(str, 'Æ', 'A');
SET str = REPLACE(str, 'Ç', 'C');
SET str = REPLACE(str, 'È', 'E');
SET str = REPLACE(str, 'É', 'E');
SET str = REPLACE(str, 'Ẹ', 'E');
SET str = REPLACE(str, 'Ẻ', 'E');
SET str = REPLACE(str, 'Ê', 'E');
SET str = REPLACE(str, 'Ệ', 'E');
SET str = REPLACE(str, 'Ề', 'E');
SET str = REPLACE(str, 'Ế', 'E');
SET str = REPLACE(str, 'Ë', 'E');
SET str = REPLACE(str, 'Ì', 'I');
SET str = REPLACE(str, 'Í', 'I');
SET str = REPLACE(str, 'Ị', 'I');
SET str = REPLACE(str, 'Î', 'I');
SET str = REPLACE(str, 'Ï', 'I');
SET str = REPLACE(str, 'Ñ', 'N');
SET str = REPLACE(str, 'Ò', 'O');
SET str = REPLACE(str, 'Ó', 'O');
SET str = REPLACE(str, 'Ọ', 'O');
SET str = REPLACE(str, 'Ô', 'O');
SET str = REPLACE(str, 'Ộ', 'O');
SET str = REPLACE(str, 'Ố', 'O');
SET str = REPLACE(str, 'Ồ', 'O');
SET str = REPLACE(str, 'Ổ', 'O');
SET str = REPLACE(str, 'Ỗ', 'O');
SET str = REPLACE(str, 'Õ', 'O');
SET str = REPLACE(str, 'Ơ', 'O');
SET str = REPLACE(str, 'Ờ', 'O');
SET str = REPLACE(str, 'Ớ', 'O');
SET str = REPLACE(str, 'Ợ', 'O');
SET str = REPLACE(str, 'Ở', 'O');
SET str = REPLACE(str, 'Ỡ', 'O');
SET str = REPLACE(str, 'Ö', 'O');
SET str = REPLACE(str, 'Ø', 'O');
SET str = REPLACE(str, 'Ủ', 'U');
SET str = REPLACE(str, 'Ù', 'U');
SET str = REPLACE(str, 'Ú', 'U');
SET str = REPLACE(str, 'Ụ', 'U');
SET str = REPLACE(str, 'Ư', 'U');
SET str = REPLACE(str, 'Ứ', 'U');
SET str = REPLACE(str, 'Ừ', 'U');
SET str = REPLACE(str, 'Ự', 'U');
SET str = REPLACE(str, 'Ử', 'U');
SET str = REPLACE(str, 'Ữ', 'U');
SET str = REPLACE(str, 'Û', 'U');
SET str = REPLACE(str, 'Ü', 'U');
SET str = REPLACE(str, 'Ý', 'Y');
SET str = REPLACE(str, 'Þ', 'B');
SET str = REPLACE(str, 'Đ', 'D');
SET str = REPLACE(str, 'ß', 'Ss');
SET str = REPLACE(str, 'à', 'a');
SET str = REPLACE(str, 'ả', 'a');
SET str = REPLACE(str, 'á', 'a');
SET str = REPLACE(str, 'ạ', 'a');
SET str = REPLACE(str, 'ắ', 'a');
SET str = REPLACE(str, 'ằ', 'a');
SET str = REPLACE(str, 'ặ', 'a');
SET str = REPLACE(str, 'ẳ', 'a');
SET str = REPLACE(str, 'â', 'a');
SET str = REPLACE(str, 'ấ', 'a');
SET str = REPLACE(str, 'ầ', 'a');
SET str = REPLACE(str, 'ậ', 'a');
SET str = REPLACE(str, 'ẩ', 'a');
SET str = REPLACE(str, 'ẫ', 'a');
SET str = REPLACE(str, 'ã', 'a');
SET str = REPLACE(str, 'ä', 'a');
SET str = REPLACE(str, 'å', 'a');
SET str = REPLACE(str, 'æ', 'a');
SET str = REPLACE(str, 'ç', 'c');
SET str = REPLACE(str, 'è', 'e');
SET str = REPLACE(str, 'é', 'e');
SET str = REPLACE(str, 'ẹ', 'e');
SET str = REPLACE(str, 'ẻ', 'e');
SET str = REPLACE(str, 'ê', 'e');
SET str = REPLACE(str, 'ệ', 'e');
SET str = REPLACE(str, 'ề', 'e');
SET str = REPLACE(str, 'ế', 'e');
SET str = REPLACE(str, 'ë', 'e');
SET str = REPLACE(str, 'ì', 'i');
SET str = REPLACE(str, 'í', 'i');
SET str = REPLACE(str, 'ị', 'i');
SET str = REPLACE(str, 'î', 'i');
SET str = REPLACE(str, 'ï', 'i');
SET str = REPLACE(str, 'ð', 'o');
SET str = REPLACE(str, 'ñ', 'n');
SET str = REPLACE(str, 'ò', 'o');
SET str = REPLACE(str, 'ó', 'o');
SET str = REPLACE(str, 'ơ', 'o');
SET str = REPLACE(str, 'ờ', 'o');
SET str = REPLACE(str, 'ớ', 'o');
SET str = REPLACE(str, 'ợ', 'o');
SET str = REPLACE(str, 'ỡ', 'o');
SET str = REPLACE(str, 'ở', 'o');
SET str = REPLACE(str, 'ọ', 'o');
SET str = REPLACE(str, 'ô', 'o');
SET str = REPLACE(str, 'ộ', 'o');
SET str = REPLACE(str, 'ố', 'o');
SET str = REPLACE(str, 'ồ', 'o');
SET str = REPLACE(str, 'ổ', 'o');
SET str = REPLACE(str, 'ỗ', 'o');
SET str = REPLACE(str, 'õ', 'o');
SET str = REPLACE(str, 'ö', 'o');
SET str = REPLACE(str, 'ø', 'o');
SET str = REPLACE(str, 'ủ', 'u');
SET str = REPLACE(str, 'ù', 'u');
SET str = REPLACE(str, 'ú', 'u');
SET str = REPLACE(str, 'ụ', 'u');
SET str = REPLACE(str, 'ư', 'u');
SET str = REPLACE(str, 'ứ', 'u');
SET str = REPLACE(str, 'ừ', 'u');
SET str = REPLACE(str, 'ự', 'u');
SET str = REPLACE(str, 'ử', 'u');
SET str = REPLACE(str, 'ữ', 'u');
SET str = REPLACE(str, 'û', 'u');
SET str = REPLACE(str, 'ý', 'y');
SET str = REPLACE(str, 'ý', 'y');
SET str = REPLACE(str, 'þ', 'b');
SET str = REPLACE(str, 'ÿ', 'y');
SET str = REPLACE(str, 'ƒ', 'f');
SET str = REPLACE(str, 'đ', 'd');
RETURN str;
END