CHARACTER SET 'UTF8MB4_0900_AI_CI' CANNOT BE USED IN CONJUNCTION WITH 'BINARY' IN CALL TO REGEXP_LIKE

CHARACTER SET 'UTF8MB4_0900_AI_CI' CANNOT BE USED IN CONJUNCTION WITH 'BINARY' IN CALL TO REGEXP_LIKE While restoring mysql i get above error? What to do??