english digit to persian digit and reverse

fa2EnDigit-en2FaDigit.sql

DROP FUNCTION IF EXISTS fa2EnDigit;
DELIMITER $$
CREATE FUNCTION fa2EnDigit(str TEXT) RETURNS TEXT
  BEGIN
    DECLARE t TEXT;
    SET t = str;
    SET t = REPLACE(t, '۱', '1');
    SET t = REPLACE(t, '۲', '2');
    SET t = REPLACE(t, '۳', '3');
    SET t = REPLACE(t, '۴', '4');
    SET t = REPLACE(t, '۵', '5');
    SET t = REPLACE(t, '۶', '6');
    SET t = REPLACE(t, '۷', '7');
    SET t = REPLACE(t, '۸', '8');
    SET t = REPLACE(t, '۹', '9');
    SET t = REPLACE(t, '۰', '0');
    RETURN t;
END$$
DELIMITER ;

DROP FUNCTION IF EXISTS en2FaDigit;
DELIMITER $$
CREATE FUNCTION en2FaDigit(str TEXT) RETURNS TEXT
  BEGIN
    DECLARE t TEXT;
    SET t = str;
    SET t = REPLACE(t, '1', '۱');
    SET t = REPLACE(t, '2', '۲');
    SET t = REPLACE(t, '3', '۳');
    SET t = REPLACE(t, '4', '۴');
    SET t = REPLACE(t, '5', '۵');
    SET t = REPLACE(t, '6', '۶');
    SET t = REPLACE(t, '7', '۷');
    SET t = REPLACE(t, '8', '۸');
    SET t = REPLACE(t, '9', '۹');
    SET t = REPLACE(t, '0', '۰');
    RETURN t;
END$$
DELIMITER ;

-- usage
SELECT fa2EnDigit("۱۳۹۵/۱۲/۹");

SELECT en2FaDigit("1395/12/9");

SELECT id, fa2EnDigit(body)
FROM post;