Utf8_unicode_ci

This article is tagged with: Utf8_unicode_ci and mysql

UTF8_UNICODE_CI

CREATE PROCEDURE randomizer()
BEGIN
DECLARE i INT DEFAULT 0;
DECLARE random CHAR(20) ;
theloop: loop
SET random = CONV(FLOOR(RAND() * 99999999999999), 20, 36);
INSERT INTO test VALUES (i+1, random);
SET i=i+1;
IF i = 500000 THEN
LEAVE theloop;
END IF;
END LOOP theloop;
END

This article is tagged with: Utf8_unicode_ci and mysql