2021-06-28

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;



No comments:

Google Referrals