MySQL Forums :: Stored Procedures :: Convert number into base 36 string

There are some problems with the above.

Here is a function that works:


DELIMITER $$

DROP FUNCTION IF EXISTS `classifieds`.`PRINTBASE` $$
CREATE FUNCTION `PRINTBASE`( num BIGINT, base SMALLINT ) RETURNS varchar(255)
DETERMINISTIC
BEGIN
DECLARE chars CHAR(36) DEFAULT "0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ";
DECLARE stream CHAR(32) DEFAULT "";
DECLARE res INT;
WHILE num > 0 DO
SET res = num % base;
SET num = num DIV base;
SET stream = CONCAT(MID( chars, res + 1, 1 ), stream);
END WHILE;
RETURN stream;

END $$

DELIMITER ;