set names utf8; DELIMITER |; DROP PROCEDURE IF EXISTS `sp_test_nick` | CREATE PROCEDURE `sp_test_nick`() BEGIN INSERT INTO test_sp SELECT null, P.NamnPåAvtal, P.Anställningsnr FROM dunno P; END | DELIMITER ;| connect (addcon, localhost, root,,); connection addcon; show variables like '%char%'; --vertical select body from mysql.proc where name = 'sp_test_nick'; --error 1457 call sp_test_nick(); set names utf8; --error 1146 call sp_test_nick(); set names latin1; --error 1146 call sp_test_nick();