Customers can't be picked in new orders

-- HikaShop version -- : 2.4.0
-- Joomla version -- : 3.4.1
-- Browser(s) name and version -- : Firefox
-- Error-message(debug-mod must be tuned on) -- : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SQL=SELECT huser.*, juser.* FROM jos_hikashop_user AS huser LEFT JOIN jos_users AS juser ON huser.user_cms_id = juser.id WHERE (huser.user_id LIKE '%ابو اياد%' OR huser.user_email LIKE '%ابو اياد%' OR juser.username LIKE '%ابو اياد%' OR juser.email LIKE '%ابو اياد%' OR juser.name LIKE '%ابو اياد%' OR huser.notes LIKE '%ابو اياد%' OR huser.status LIKE '%ابو اياد%') ORDER BY huser.user_id asc LIMIT 0, 20

Hi,
In back-end,,, I create users through user management-Joomla-backend. Then I create orders for them.
Problem when picking a customer in a new order. It always pick a spicifc customer no matter whom I choose. All new created users has the ID = 0 in hikashop.
After several picking tries, the top error message has appeared.

Hi,,
Found the problem.
Used Fabrik to create new customers in joomla back-end. It disabled AI form coulmn "user-id".
Sorry

Hi,

It seems to be an issue with your table collation in the database.
So through phpMyAdmin please edit the collation of your tables to have a unique one: "utf8_general_ci".
You will have to check the tables and the columns too, you can start by the tables "jos_users", "jos_hikashop_user".