LARAVEL 5.4 SQLSTATE[HY000]: General error: 1271 on godaddy server

Question

I'm encounter an error when i do search the chinese character in laravel, it gave me General error: 1271,

here is my code:

$sales_record = SalesRecord::select(DB::raw('sales_records.id as id, sales_records.amount as amount, clients.name as name, sales_records.created_at as created_at, sales_records.updated_at as updated_at '))
                                  ->join('clients', 'sales_records.client_id', '=', 'clients.id')
                                  ->Where('sales_records.amount', 'LIKE', '%' . $search . '%')
                                  ->orWhere('clients.name', 'LIKE', '%' . $search . '%')
                                  ->orWhere('sales_records.created_at', 'LIKE', '%' . $search . '%')
                                  ->orWhere('sales_records.updated_at', 'LIKE', '%' . $search . '%')
                                  ->orderBy('sales_records.created_at', 'DESC')
                                  ->paginate(10);

And here is the error

And this error only appear on my godaddy share hosting, there is no error in my localhost.

Anyone know how to solve this error?

Check the collation for all joined tables. It should be the same. — apokryfos, Apr 11 '17 at 15:31
@apokryfos the collation of table is utf8mb4_unicode_ci, and the database is utf1_general_ci — Blu Ycw, Apr 11 '17 at 15:48
@BluYcw is that the collation of all tables that are joined? — apokryfos, Apr 11 '17 at 15:49
@apokryfos sorry, i'm not sure what you mean join the collation of table, but i use "join" keyword in my sql to join 2 table, if not, can you tell me how to join the collation of the table? thank you — Blu Ycw, Apr 11 '17 at 16:10
My question is is `utf8mb4_unicode_ci` the collation of `sales_records` **and** `clients` ? — apokryfos, Apr 11 '17 at 16:15
Check: https://laravel.com/docs/5.0/database#configuration make sure your `charset` is `utf8mb4` and your collation matches `utf8mb4_unicode_ci` in your configuration. — apokryfos, Apr 11 '17 at 16:28
Check http://stackoverflow.com/questions/18629094/illegal-mix-of-collations-for-operation-like-while-searching-with-ignited-data . It may be an issue with using LIKE and a `DATETIME` field in some MySQL versions. — apokryfos, Apr 11 '17 at 16:37
@apokryfos its working now, i remove the like statement that compare with timestamp then it work, thanks for help — Blu Ycw, Apr 11 '17 at 16:44
What client are you using for entering the Chinese literals? — Rick James, Apr 12 '17 at 03:47

LARAVEL 5.4 SQLSTATE[HY000]: General error: 1271 on godaddy server

0 Answers0