create database usersTest;
use usersTest;

CREATE TABLE `userTest` (
  `id` varchar(36) CHARACTER SET utf8 NOT NULL,
  `username` varchar(100) CHARACTER SET utf8 NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UC_USERTEST_USERNAME` (`username`),
  `status` varchar(50) NOT NULL
);

insert into userTest(`id`, `username`, `status`) values ('2a812430-608e-423f-8828-952b9c94b6d4', 'dummy', 'Locked');

DELIMITER $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_varcharTest`(In userNameParam varchar(100))
    SQL SECURITY INVOKER
BEGIN
              EXPLAIN update userTest set status = 'Active' where username = userNameParam;
END$$
DELIMITER ;

DELIMITER $$
CREATE DEFINER=`root`@`%` PROCEDURE `sp_nvarcharTest`(In userNameParam nvarchar(100))
    SQL SECURITY INVOKER
BEGIN
              EXPLAIN update userTest set status = 'Active' where username = userNameParam;
END$$
DELIMITER ;

call sp_varcharTest('dummy');

call sp_nvarcharTest('dummy');