mysql - Creating a stored procedure with utf8 strings -

i have stored procedure cyrillic strings inside. want check table char column if column contains specific strings, of them in cyrillic. problem seems cannot create procedure strings.

set names utf8;  delimiter // drop procedure if exists testutf8 // create procedure testutf8() begin     select 'ξενοδοχια'; end // delimiter ;   call testutf8(); 

returns ?????????

show create procedure testutf8; 

returns

procedure testutf8

sql_mode strict_trans_tables

create procedure "create definer=xxx@% procedure testutf8() begin select '?????????'; end"

character_set_client utf8

collation_connection utf8_general_ci

database collation latin1_swedish_ci

so despite me using set names utf8; server turns code latin1 seems. how can fix this?

adding ?characterencoding=utf8 server url did trick.