Is working - while create function: ERROR 1418 (HY000) & ERROR 1267 (HY000)

 

SHOW VARIABLES LIKE '%char%';

ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you *might* want to use the less safe log_bin_trust_function_creators variable)

Source URL: https://stackoverflow.com/a/26015334

1. Execute the following in the MySQL console:

   SET GLOBAL log_bin_trust_function_creators = 1;

ERROR 1267 (HY000): Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='

drop table

and recreate table with 

CREATE DATABASE new_table DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_unicode_ci;