Re: Convert number into base 36 string

[Peter Brawley]

You forgot to divide, eg...

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
IF num < 36 THEN
SET res = num;
SET num = 0;
ELSE
SET res = num / base;
SET num = num % base;
END IF;
SET stream = CONCAT( stream, MID( chars, res, 1 ));
END WHILE;
RETURN stream;
END;