Re: Numeric equivalents of characters

[Rick James]

Converting a word would probably take a Stored Procedure, something like:

DELIMITER //
CREATE STORED PROCEDURE Unicode2Num(
        IN _word VARCHAR(99)
)
BEGIN
    SET @word := _word;
    WHILE (LENGTH(@word) > 0)
    BEGIN
        SELECT CONCAT(ord(convert(LEFT(@word, 1) using ucs2)), ' ';
        SET @word := MID(@word, 1);
    END
END //
DELIMITER ;
-- Sample usage:
CALL Unicode2Num('באב');

(Caveat: there may be errors; I did not test the code.)