Resolved - General error: 1267 Illegal mix of collations

[rbiscaino]

Hi everyone, I recently had a problem creating new categories in Bagisto Admin, I got an error with Illegal Mix of Collactions and couldn't find a solution to this problem, so I dug a little deeper into the root causes and verified that this was a problem with character and grouping in my database, as there is a trigger that is executing information and concatenating data, I am using MySql 8 and to solve my problem I made the following instruction: In the my.cnf file of your Mysql insert the following code:

[server]
     collation-server = utf8_general_ci
     init-connect='SET NAMES utf8'
     character-set-server = utf8

I hope I could help, a big hug to everyone

[ashish2409]

@rbiscaino
Hello there,
May I know which version of Bagisto you are using so that we can help you.
If you are using V1.5.0 or above kindly use DB collection utf8mb4_unicode_ci.

Thank You.