after im upgrade from HeidiSQL_9.3.0.5107 to latest, date or number where set to variable become HEX values. So i must convert/cast again.
for example :
set @"a"=now();
set @"b"=123;
select @"a" , date(@"a"), convert (@"a" using utf8) , @"b", convert (@"b" using utf8);
result :
|| *@"a"* || *date(@"a")* || *convert (@"a" using utf8)* || *@"b"* || *convert (@"b" using utf8)* ||
|| 0x323031372D30322D31302031333A35313A3338 || 2017-02-10 || 2017-02-10 13:51:38 || 0x313233 || 123 ||
Here mysql.ini character_set_client, character_set_connection, character_set_results, character_set_server = utf8 collation_connection, collation_server = utf_general_ci collation_database = latin1_swedish_ci