Update from 8.4 to 9.0 Illegal mix of collations (

Installing my Dolibarr
1

I have this error
Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation ‘=’

In "accounting->Post invoices to customers->Lines to be posted
Then this error.
same error In "accounting->Post supplier invoices>Lines to be posted

All Ok in 7.x and 8.x then at 9,00 this error.
Any idea?
Thanks.

2

Hello,

You will need a SQL access to your Dolibarr database but you can use this

the collation (utf8_unicode_ci or utf8_general_ci) depends on what you have here http(s)://<yourdolibarr>/admin/system/database.php