mysql 将数字转为汉字

DELIMITER $$

CREATE FUNCTION NumberToChinese(num INT) RETURNS VARCHAR(255)
BEGIN
    DECLARE result VARCHAR(255);
    DECLARE units VARCHAR(20) DEFAULT '十百千万亿';
    DECLARE nums VARCHAR(20) DEFAULT '零一二三四五六七八九';
    DECLARE len INT DEFAULT LENGTH(num);
    DECLARE i INT DEFAULT 1;
    DECLARE currentDigit CHAR(1);
    DECLARE currentUnit VARCHAR(2);

    SET result = '';

    WHILE i <= len DO
        SET currentDigit = SUBSTRING(num, -i, 1);
        SET currentUnit = SUBSTRING(units, (len - i) % LENGTH(units) + 1, 1);

        IF currentDigit <> '0' THEN
            SET result = CONCAT(nums, currentUnit, result);
        ELSEIF SUBSTRING(result, 1, 1) <> nums THEN
            SET result = CONCAT(nums, result);
        END IF;

        SET i = i + 1;
    END WHILE;

    RETURN result;
END$$

DELIMITER ;

SELECT NumberToChinese(123456); -- 输出：十二万三千四百五十六
SELECT NumberToChinese(10000);  -- 输出：一万
SELECT NumberToChinese(0);      -- 输出：零