Cannot delete Category

[golith]

Illuminate \ Database \ QueryException (HY000)
SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' (SQL: update categories set _lft = case when _lft between 15 and 16 then _lft-1 when _lft between 14 and 16 then _lft+2 else _lft end, _rgt = case when _rgt between 15 and 16 then _rgt-1 when _rgt between 14 and 16 then _rgt+2 else _rgt end where (_lft between 14 and 16 or _rgt between 14 and 16))

any ideas about this error

[devansh-webkul]

Hi @golith,

Please use utf8_unicode_ci when creating a database.

[golith]

so when i create the database in the first instance i need to declare it .. ty
CREATE DATABASE bagisto CHARACTER SET utf8 COLLATE utf8_general_ci;